The If-Then function in Excel is one of the more basic functions. You can formulate this as a condition, the arrival must, to a certain rule to derive. We will tell you how to build the function.
Structure of an If-Then function in Excel
The structure of the If-Then function is relatively simple and always the same. The formula for this is: IF(condition; Then; Else). If the condition is true, then the executed statement. Is not the condition to execute the Else statement. The instructions can be arbitrarily complicated, you may not so If-Then-functions boxes.
Simple example of If-Then
On the picture you can see a simple example of the If-Then function. If the number is next to the selected field is greater than 5, it will display "Greater than 5". Otherwise, it will display "Less than 5".