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

Was this helpful?
How can we improve it?