Microsoft® Office Excel® 2007 Plain & Simple

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 their previous times. 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 ...