The IF function adds flexibility to your spreadsheets by introducing decision making. It does this by testing a specified condition in your spreadsheet to see if it is true or false.
If the condition is true, the function will carry out one action. If the condition is false, it will carry out a different action.
The function allows you to specify what these actions should be. They can include executing a formula, inserting a text statement, displaying number data, or leaving the target cell blank.
To find out more about how this function works, read this tutorial on the Excel IF Function.Related Tutorials