Home > Sample chapters > Microsoft Office > Excel

Using Formulas and Functions

Using the IF Function

In addition to calculating values based on the contents of other cells, you can have Excel take different actions based on the contents of those other cells by using the IF function. For example, if you create a workbook to track the times of riders in a bicycle-racing club, you can create a formula to compare each rider’s time to his previous time. When someone’s most recent time is the lowest time in the group, you can have Excel display Personal Best in the cell with the formula, alerting you to congratulate the rider in your next club newsletter.

Create an IF Function

  1. Click the cell in which you want to enter an IF function.

  2. Click the Formulas tab.

  3. Click Logical.

  4. Click IF.

  5. Type a conditional statement that evaluates to true or false.

  6. Type the text you want to appear if the condition is true.

  7. Type the text you want to appear if the condition is false.

  8. Click OK.