Microsoft Office Tutorials and References
In Depth Information
Chapter 8: IF Functions
to type
yes
when they are larger and
no
when they are not. I use the IF function
to do so.
I inserted the IF function in cell C2:
¼
IF (A2
B2,
yes
,
no
)
>
The IF function in cell C2 has three parts: The logical test is A2
B2. The value if
>
it is true is
yes.
The value if it is false is
no.
See Figure 8.2.
For cell C2, the result should be
yes.
See Figure 8.3.
For cell C3, the result should be
no
”—
since the value in A3 is equal to the value
in B2
not greater. The rest of the results are shown in Figure 8.4. The left side of
FIGURE 8.2 The IF Function
FIGURE 8.3 The Group 1 Number Is Larger than the Group 2 Number
FIGURE 8.4 The IF Functions and the Results
Search JabSto ::




Custom Search