The Excel 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 actions it should carry out depending on whether the condition is true or not. These actions can include executing a formula, inserting a text statement, or leaving the target cell blank.
To find out more about how this function works, read the step by step tutorial on the Excel IF Function.Related Tutorials