If

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.

Returns

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

Example 1

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")

Example 2

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"))

Example 3

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))

Example 4

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