Using the IF Function in Excel 2007

Using the IF function, you can tell Excel to evaluate a condition and perform one of two calculations based on that condition.  The two calculations are based on whether the condition is true or false.  For example, if the sales of a store was greater than 5000, you could give the manager a $2,000 bonus (condition is true); if the sales were less than $5000, the manger would get a $500 bonus (condition is false).

You can either type the IF function directly into the cell or click the Insert Function button and use the Insert Function dialog box.

Using the example above, the format of the IF function is:

To Use the IF Function

1. Activate the cell in which you want to place the formula.
2. Type:  =IF(
3. Enter the condition for which to test, followed by a comma.
4. Enter the value if the condition is true followed by a comma.
5. Enter the value if the condition is false.
6. Type ) close the formula.
7. Press the Enter key to verify the formula.

Similar Posts:

• Using the VLOOKUP Function in Excel
• Understanding Date/Time Functions in Excel
• Using the PMT Function in Excel 2007
• Entering in Functions Manually in Excel
• Using the Insert Function button in Excel
• Add Comments to a Formula in Excel
• Using the FV Function in Excel

Tagged as: Excel 2007 Tips, Microsoft Office Tips, Using the IF Function