Page 83 - Excel Data Analysis

05 537547 Ch04.qxd 3/4/03 11:52 AM Page 69

CREATING FORMULAS 4

If you want to check for multiple conditions, you
can use what is commonly referred to as nested TYPE THIS:
IF function statements. When you nest the IF
functions, you specify an IF function as the =IF(A1>100, IF(A1<200, A1*1.1, A1+25), A1+10)
value of either the value_if_true or the
value_if_false argument. You can combine,
or nest, up to seven levels of IF functions within RESULT:
one formula.
The following example checks that a price falls A1 VALUE RESULT
within a specific range. The example uses two IF
50 50+10
functions. The value of the Value_If_True
argument is the second IF Function. The first IF 125 125+25
function checks A1 to see if it is larger than 100. If 225 225*1.1
so, the second IF statement checks if A1 is over
200. If this condition is met, Excel multiplies A1 by
110%. If the value is between 101 and 200, Excel
adds 25 to the value in A1. If the value is less than
100, Excel adds 10, using the Value_If_False
argument of the first IF statement. The following
table provides a quick look at what Excel does
based upon the value in A1.

ˇ Type the value if the Á Type ). ■ Excel creates the formula
condition is False. and displays the appropriate
‡ Press Enter.
result after checking the
condition.

69