NEReturns “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