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 againstvalue1
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.