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