I P IF Function N


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
4comparing # 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


I P IF Function N

1055917

Choose:   INTEK home   I   training  I   by Jim Tracy   I