IF

See also A-Z Spreadsheet Function List

Description Tests the condition and returns the specified value.

Syntax IF(condition, true_value, false_value)

condition is any logical expression.

true_value is the value to be returned if condition evaluates to True.

false_value is the value to be returned if condition evaluates to False.

See Also AND , FALSE , NOT , OR , and TRUE functions

Example IF(A1>10, “Greater”, “Less”) returns Greater if the contents of A1 is greater than 10 and Less if the contents of A1 is less than 10.