IF Function

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

zelda 3.07 SERIAL

IF Function

zelda 3.07 SERIAL

968252

Choose: TRIO home zelda 3.07 SERIAL I tutorials zelda 3.07 SERIAL I by Brad James zelda 3.07 SERIAL I bwjames@usd.edu zelda 3.07 SERIAL