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)

Free 2027 printable calendar in Google Sheets The whole year on one page. Copy it to your Drive, plan the big dates, and print it as a PDF. Get the free calendar

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

Ads keep the free stuff free. Members browse ad-free — log in or see pricing.