IF Function

  • Article

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.