IF Function
Returns valueiftrue if logicalexpression is TRUE. Otherwise, it returns valueiffalse.
Syntax
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
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.