Conditional Operators

When using the conditional operators in Table 30 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 30. Conditional Operators

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