Using Formulas and Functions
- Understanding Formulas and Cell References in Excel
- Creating Simple Cell Formulas
- Assigning Names to Groups of Cells
- Using Names in Formulas
- Creating a Formula That References Values in an Excel Table
- Creating Formulas That Reference Cells in Other Workbooks
- Summing a Group of Cells Without Using a Formula
- Creating a Summary Formula
- Summing with Subtotals and Grand Totals
- Exploring the Excel Function Library
- Using the IF Function
- Checking Formula References
- Debugging Your Formulas
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
Click the cell in which you want to enter an IF function.
Click the Formulas tab.
Type a conditional statement that evaluates to true or false.
Type the text you want to appear if the condition is true.
Type the text you want to appear if the condition is false.