Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.