BOOL

Evaluates a string with a logical value (ignoring case) and returns true when the string equals "true", "T", "yes" or "Y", or if it contains a non-zero number. Otherwise, it returns false

BOOL(value)

BOOL('YES')

This expression would return true

BOOL('NO')

This expression would return false

BOOL(1)

This expression would return true

IF

Checks whether a specified condition is met. If it is, returns the first specified value; otherwise, returns the second specified value.

IF(text,expr1,expr2)

IF(@NET_PRICE>1000,'Expensive','Cheap')

If the expression in the field is TRUE (the value is greater than 1000), the value Expensive is returned. If the expression is FALSE (the value is less than 1000), the value Cheap is returned.

IF(@@=='DE','Germany','Other')

If the string DE is TRUE, the value returned is Germany. Otherwise, the value returned is Other

IF(@BANK_CTRY=='US',United States', IF(BANK_CTRY=='GB','England',IF(@BANK_CTRY=='IL','Israel',IF(@BANK_CTRY=='DE','Germany','Other'))))

A nested IF expression defining display text for country names. If the value returned is not US, GB, IL or DE, the value returned is Other

ISNULL

Returns TRUE if a reference is to an empty, undefined or null cell; otherwise, returns FALSE

ISNULL(value)

IF(ISNULL(@@),'NO FAX NUMBER', @@)

If the value of the current cell is empty, the value returned is NO FAX NUMBER; otherwise, the value of the current cell is returned.

NVL

Returns the value of the first non-empty or undefined string in a given set of values. If all argument items are empty, returns an empty string.

NVL(v1,v2)

NVL('a', 'b')

Returns the value of the first non-empty string in the set of values; in this case: a

NVL('', 'b')

In this case, the first string is empty, so that the value of the second item is returned: b