Microsoft Office Tutorials and References
In Depth Information
EX 190
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
To Enter an IF Function
The following steps assign the IF function =IF(B4>=\$B\$24,\$B\$19,0) to cell B9. This IF function determines
whether or not the worksheet assigns a bonus for January.
1
Click cell B9. Type
=if(b4>=\$b\$24,
\$b\$19,0) in the cell
(Figure 3–28).
Excel colors border
of cells used in
formula
if value in cell B4 is greater
than or equal to 4,750,000,
then bonus equals 100,000;
otherwise, bonus equals 0
IF function typed
in active cell
Excel colors border
of cells used in
formula
Figure 3–28
2
Click the Enter box
in the formula bar
to display 0 in
cell B9 (Figure 3–29),
because the value in
cell B4 (3383909.82)
is less than the value
in cell B24 (4,750,000)
(Figure 3-29).
Why does the value
0 display in cell B9?
The value that Excel
displays in cell B9
depends on the
values assigned to
cells B4, B19, and
B24. For example, if the value for January sales in cell B4 is reduced below 4,750,000.00, then
the IF function in cell B9 will cause Excel to display a 0. If you change the bonus in cell B19 from
100,000.00 to another number and the value in cell B4 is greater than or equal to the value in
cell B24, it will change the results in cell B9 as well. Finally, increasing the revenue for bonus
in cell B24 so that it is greater than the value in cell B4 will change the result in cell B9.
IF function
assigned to
cell B9
value of 0 assigned to cell
B9 because value in cell
B4(3383909.82) is less than
value in cell B24 (4,750,000.00)
Figure 3–29
Other Ways
1. On Formulas tab on
Ribbon, click Logical
button, click IF
2. Click Insert Function
box in formula bar, click
Logical in ‘Or select a
category list’, click IF in
drop-down list, click
OK button

Search JabSto ::

Custom Search