What-If Analysis, Charting, And Working With Large Worksheets Page 30
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87EX 166
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
2
•
Click the OK button
(Insert Function dialog
box) to display the
Function Arguments
Function Arguments
dialog box
dialog box.
b13>=$b$7
•
Type
b13>=$b$7 entered
IF function to be
in the Logical test box
in Logical test box
assigned to cell B18
to enter a logical test
current values
for the IF function.
$b$2 entered in
of expressions
Value_if_true box
displayed
$b$2
•
Type
in the
Value_if_true box to
enter the result of
0 entered in
Value_if_false box
the IF function if the
logical test is true.
OK button
0
•
Type
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
IF function assigned
to cell B18
the selected cell
(Figure 3 –30).
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
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education