true when two values differ · from google sheets · no excel equivalent · sheets: not yet compared

signature

NE(value1, value2)

returns: boolean

argument	required
value1	required
value2	required

examples

formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.

related

• AND returns TRUE if all arguments are true
• EQ true when two values are equal
• FALSE returns the logical value FALSE
• GT true when the first number is greater
• GTE true when the first number is greater or equal
• IF returns one value if condition is true, another if false