Better Sheets

How to Use NE() in Google Sheets

Description

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

How To Actually Use NE() in Sheets

NE(value1, value2)

Try NE yourself

In cells C1:C10, use the NE() formula to compare values in A1:A10 with values in B1:B10. The formula should return TRUE if the values are not equal and FALSE if they are equal.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Better 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.

EQ() NE()

Transcript-matched member videos for NE(). Click through to watch.

Watch more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

Embed a Number in a Website from a Google Sheet

Ever wanted to display some data from a google sheet on your site? Witho...

Advanced

Unlock these tutorials

Learn more about the NE() formula:

Generate a NE() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses NE(). 2 free AI generations, no signup. Members get unlimited use.

Generate a NE() formula