NE()

Description

Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator.

How To Use in Sheets

NE(value1, value2)

External Links

Equal and Not Equal

Discover the EQUAL and NOT EQUAL functions. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials!

Google Docs Help

1Better Sheets Tutorial

Equal, Equal, Not Equal, Not Equal - How to Tell if Two Cells are the Same or Not The Same

Discover 4 easy ways to check if 2 cells in Excel are equal or not! Whether it's numbers, text, or dates, get the answer in seconds with simple tricks. Learn now in this video.