IF function

See also

Returns valueiftrue if logicalexpression is TRUE. Otherwise, it returns valueiffalse.

Syntax

IF(logicalexpression,valueiftrue,valueiffalse)

Example

IF(Height > 1.25 in.,5,7)

Returns 5 if the shape's height is greater than 1.25 inches. Returns 7 if the shape's height is less than or equal to 1.25 inches.