81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

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!

1Better Sheets Tutorial

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.