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.