IF Function

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

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

IF(logicalexpression,valueiftrue,valueiffalse)

Parameters

Name

Required/Optional

Data Type

Description

logicalexpression

Required

String

Expression to evaluate.

valueiftrue

Required

Varies

Value to return if logicalexpression is true.

valueiffalse

Required

Varies

Value to return if logicalexpression is false.

Return Value

Varies

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: