@IF

A logical test.

Syntax

@IF(i LogicalTest, nt1, nt2)

Argument	Description
i1	A logical test.
nt1	The value or string to return if the test is true, or evaluates greater than 0.
nt2	The value or string to return if the test in false, or evaluates to 0 or less.

Logic

The test returns n2 (value) or t1 (string) if the test is true, n2 or t2 if the test is false.

The @IF function can return a text string as a result.

The row must be of Text type.

Examples

@IF(41, 10, 20) returns 10

@IF(3 > 4, 10, 20) returns 20

@IF(a+b > c-d, x*y, x/y)

@IF(Roster==7, "7DayRoster", "5DayRoster")

@IF(Country=="Australia", "AUD", "USD")

Conditions

==, >, <, >=, <=, <>