IF Function

---

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

---

IF Function

540778