Microsoft Office Tutorials and References

In Depth Information

**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).

IF function

assigned to

cell B9

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.

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