Microsoft Office Tutorials and References
In Depth Information
Making Decisions — The IF Function
2
Click the OK button
(Insert Function dialog
box) to display the
Function Arguments
dialog box.
Function Arguments
dialog box
Type
b13>=$b$7
in the Logical test box
to enter a logical test
for the IF function.
b13>=$b$7 entered
in Logical test box
IF function to be
assigned to cell B18
current values
of expressions
displayed
$b$2 entered in
Value_if_true box
Type
$b$2 in the
Value_if_true box to
enter the result of
the IF function if the
logical test is true.
0 entered in
Value_if_false box
OK button
Type
0 in the
Value_if_false box
to enter the result of
the IF function if the
logical test is false
(Figure 3 – 29).
Figure 3–29
3
Click the OK button
(Function Arguments
dialog box) to insert
the IF function in
the selected cell
(Figure 3 – 30).
IF function assigned
to cell B18
value of 0 assigned to cell
B18 because value in cell B13
(3113612.16) is less than the
value in cell B7 (3,500,000.00)
Figure 3–30
Why is the value 0 displayed in cell B18?
The value that Excel displays in cell B18 depends on the values assigned to cells B13, B2, and
B7. For example, if the value for July revenue in cell B13 is increased above 3,500,000.00,
then the IF function in cell B18 will cause Excel to display 200,000.00. If you change the sales
revenue for bonus in cell B7 from 3,500,000.00 to another number and the value in cell B13
is greater than or equal to the value in cell B7, it will change the results in cell B18 as well.
Other Ways
1. Click Logical button
(Formulas tab | Function
Library group), click IF
 
Search JabSto ::




Custom Search