NE

Returns “TRUE” if two specified values are not equal and “FALSE” otherwise. Equivalent to the ”<>” operator.

Sample Usage

NE(A2,A3)

NE(2,3)

Syntax

NE(value1, value2)

• value1 - The first value.
• value2 - The value to test against value1 for inequality.

See Also

LTE: Returns TRUE if the first argument is less than or equal to the second, and FALSE otherwise. Equivalent to the <= operator.

LT: Returns TRUE if the first argument is strictly less than the second, and FALSE otherwise. Equivalent to the < operator.

GTE: Returns TRUE if the first argument is greater than or equal to the second, and FALSE otherwise. Equivalent to the >= operator.

GT: Returns TRUE if the first argument is strictly greater than the second, and FALSE otherwise. Equivalent to the > operator.

EQ: Returns “TRUE” if two specified values are equal and “FALSE” otherwise. Equivalent to the ”=” operator.

Examples