| |
The next function we will discuss is IF. The IF function will
check the logical condition of a statement and return one value if true
and a different value if false. The syntax is
- =IF (condition, value-if-true, value-if-false)
- value returned may be either a number or text
- if value returned is text, it must be in quotes
Lets use the table here for the discussion that
follows. We will look at several different specific examples that show
how the IF functions can be used! |
|
A |
B |
1 |
Price |
Over a dollar? |
2 |
$.95 |
No |
3 |
$1.37 |
Yes |
4 | comparing # |
returning # |
5 |
14000 |
0.08 |
6 |
8453 |
0.05 |
|
Example of IF typed into column B |
Compares |
Answer |
=IF (A2>1,"Yes","No") |
is ( .95 > 1) |
No |
=IF (A3>1, "Yes", "No") |
is (1.37 > 1) |
Yes |
=IF (A5>10000, .08, .05) |
is (14000 > 10000) |
.08 |
=IF (A6>10000, .08, .05) |
is (8453 > 10000) |
.05 |
1055917 |