This documentation is archived and is not being maintained.

IF function

IF function

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

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.

Show: