NE

Returns TRUE if the specified values are not equal and FALSE otherwise.

Sample Usage

NE(5,10)
NE(A4,A5)

Syntax

NE(value1, value2)

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

Examples

NE(5,10) evaluates to TRUE.
NE(A4,A5) evaluates to TRUE if the values in A4 and A5 are not equal. It evaluates to FALSE if the values in A4 and A5 are equal.