Opening the IF Function Dialog Box
In this tutorial, we want to use the same function in a number of cells. The first step will be to enter the function into one cell in the group and then copying it to the rest.
- Click on cell F6 to make it the active cell. This is where we will enter the IF function.
- Click on the Formulas tab.
- Click on the Logical icon on the ribbon to open the Logical function drop down list.
- Click on IF in the list to bring up the IF function's dialog box.
The data that we enter into the three blank rows in the dialog box will form the arguments of the IF function.
These arguments tell the function what condition we are testing and what actions to take depending on whether the condition is true or not.