IF

Returns one value if a logical expression is TRUE and another if it is FALSE.

Syntax

IF(logicalExpression, valueIfTrue, [valueIfFalse])

• logicalExpression - An expression or reference to a cell containing an expression that represents some logical value, i.e. TRUE or FALSE.

• valueIfTrue - The value the function returns if logicalExpression is TRUE.

• [valueIfFalse] - The value the function returns if logicalExpression is FALSE. If omitted, FALSE will be returned if expression is FALSE.

Sample Usage

IF( A2 = "student", TRUE, FALSE)

Return Value

• TRUE if the value of the logicalExpression is TRUE.

• FALSE otherwise.

Notes

See Also