- By Curtis Frye
- 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
- Changing links to different workbooks
- Analyzing data by using the Quick Analysis lens
- 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 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
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 that you want to appear if the condition is true.
Type the text that you want to appear if the condition is false.