Conditional Operators

When using conditional operators, consider the following:

• Expression can be any valid formula expression. The expression can be any combination of a constant (integer or real number), a reference, or another function.

• Reference can be any valid reference; thus the IFNN reference property can be utilized as part of the reference.

• Condition can be any valid condition applied to the complex conditions And, Not, and Or. These operators can have embedded conditions. (And, Not, and Or operators require surrounding parentheses.)

• When any expression within the condition returns an #error or #missing value, the If function returns #missing or #error. This does not apply when you use the IsMissing, IsError, or IsNonNumeric conditions.

Table 10-10 Conditional Operators

Conditional Operator	Syntax	Logic
Equal To	expression = expression	Tests if the left expression is equal to the right expression. 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. 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. 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. 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. 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. 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. 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)	Groups a condition. Example: (1 > 4) returns false.