IfThen, If

IfThen is a conditional function that returns a value when the condition equals True, and another value when the condition equals False.

The function syntax is as follows:

  IfThen(Condition, TrueParameter, FalseParameter)

Condition is a logical expression that evaluates to true or false. Full conditional logic can be used as well as complex Boolean operators (And, Not, and Or). A condition can also test for #missing and #error values. See the following table for a list of valid conditional operators.
TrueParameter and FalseParameter are any valid expression that are evaluated based on the outcome of the condition.

The following table describes the conditional operators that are fully supported. Alternate syntax is listed wherever it is supported by a conditional operator.

Table 41. Conditional Operators

Conditional Operator	Syntax	Logic
Equal To	expression = expression	Tests if the left expression is equal to the right expression. Note: The routine that evaluates the condition does not consider any rounding. If rounding is required, use the Round function. Example: 1= 4 Returns false
Greater Than	expression > expression	Tests if the left expression is greater than the right expression. Example: 1 > 4 Returns false
Greater Than or Equal To	expression >= expression	Tests if the left expression is greater than or equal to the right expression. Note: The correct syntax is “>=”. The syntax “=>” is not supported. Example: 1 >= 4 Returns false
Less Than	expression < expression	Tests if the left expression is less than the right expression. Example: 1 < 4 Returns true
Less Than or Equal To	expression <= expression	Tests if the left expression is less than or equal to the right expression. Note: The correct syntax is “<=”. The syntax “=<” is not supported. Example: 1 <= 4 Returns true
Not Equal To	expression <> expression expression != expression	Tests if the left expression is not equal to the right expression. Note: The routine that evaluates the condition does not consider any rounding. If rounding is required, use the Round function. Example: 1 <> 4 Returns true 1 != 4 Returns true
IsMissing	IsMissing (reference) IsMiss (reference)	Tests if the reference contains a #missing result. Note: If the reference is an expanded row or column, then all resulting cells must be #missing in order for the condition to be true. Example: IsMissing([1]) Returns true if row 1 has a #missing value.
IsError	IsError (reference) IsErr (reference)	Tests if the reference contains an #error result. Note: If the reference is an expanded row or column, all resulting cells must be #error in order for the condition to be true. Only formula rows and columns can result in #error. Example: IsError([2]) Returns true if row 2 has a #error value.
IsNonNumeric	IsNN (reference) IsNonNumerid (reference) IfNN (reference) IfNonNumber (reference)	Tests if the reference contains a #missing or #error results. Note: If the reference is an expanded row or column, all resulting cells must be #missing and/or #error in order for the condition to be true. Example: IsNN([3]) Returns true if row 3 has a #missing or #error value.
Parenthesis	(condition)	Used to group a condition. Mostly used for visual clarity. Example: (1 > 4) Returns false

Table 42. Complex Conditions

Complex Conditions	Syntax	Logic
And	(condition AND condition) (condition & condition)	Complex condition used to compare two conditions. Returns true if all conditions result in true. Example: (1 > 4 AND 5 > 2) Returns false
Not	NOT (condition) ! (condition)	Used to negate the result by reversing the result of the condition. Example: Not (1 > 4) Returns true
Or	(condition OR condition) (condition \| condition)	Complex condition used to compare two conditions. Returns true if any of the conditions result in true. Example: (1 > 4 OR 5 > 2) Returns true

Complex Conditions

Syntax

Logic

And

(condition AND condition)

(condition & condition)

Complex condition used to compare two conditions. Returns true if all conditions result in true.

Example:

(1 > 4 AND 5 > 2)

Returns false

Not

NOT (condition)

! (condition)

Used to negate the result by reversing the result of the condition.

Example:

Not (1 > 4)

Returns true

(condition OR condition)

(condition | condition)

Complex condition used to compare two conditions. Returns true if any of the conditions result in true.

Example:

(1 > 4 OR 5 > 2)

Returns true