Description
Evaluates a condition and returns a value based on that condition.
Syntax
If ( boolean, truevalue, falsevalue )
|
Argument |
Description |
|---|---|
|
boolean |
A boolean expression that evaluates to true or false. |
|
truevalue |
The value you want returned if the boolean expression is true. The value can be a string or numeric value. |
|
falsevalue |
The value you want returned if the boolean expression is false. The value can be a string or numeric value. |
Return value
The datatype of truevalue or falsevalue. Returns truevalue if boolean is true and falsevalue if it is false. Returns null if an error occurs.
Examples
This expression returns Boss if salary is over $100,000 and Employee if salary is less than or equal to $100,000:
If(salary > 100000, "Boss", "Employee")
This expression returns Boss if salary is over $100,000, Supervisor if salary is between $12,000 and $100,000, and Clerk if salary is less than or equal to $12,000:
If(salary > 100000, "Boss", If(salary > 12000, "Supervisor", "Clerk"))
In this example of a validation rule, the value the user should enter in the commission column depends on the price. If price is greater than or equal to 1000, then the commission is between .10 and .20. If price is less than 1000, then the commission must be between .04 and .09. The validation rule is:
(Number(GetText()) >= If(price >=1000, .10, .04)) AND (Number(GetText()) <= If(price >= 1000, .20, .09))
The accompanying error message expression might be:
"Price is " + If(price >= 1000, "greater than or equal to", "less than") + " 1000. Commission must be between " + If(price >= 1000, ".10", ".04") + " and " + If(price >= 1000, ".20.", ".09.")
See also
Example 1: counting null values in a column
Example 2: counting active and terminated employees
Example 3: creating a row indicator
