If-Then-Else – one of the functions that Excel has taken from the programming languages. And it is one of those things that one learns as basics of programming.
If-Then-Else (or simply IF function) is used to make a choice based on condition(s) provided by the user. For example: