Jayson's Blog #4 In CompSci for 3rd Rating

IF

www.bluemoosetech.com

blog.contextures.com

If Function

-  returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE.

IF(logical_test, [value_if_true], [value_if_false])

=IF(A1>=True,“True",“False")

Example (single range) 

=IF(AND(G1>60,G1<100),“passed",“failed")

Nested IF (exact value) 

=IF(J1=29,“Twenty- nine", IF(J1=0,“Zero",”Invalid”)) 

Nested IF (ranges) 

=IF(AND(A1>0,A1<11),“One to Ten", 

IF(AND(A1>15,A1<30), 

“Fifteen to Thirty",“Invalid"))