How to Use EQ() in Google Sheets

Description

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

How To Actually Use EQ() in Sheets

EQ(value1, value2)

Try EQ yourself

In cells D1:D10, use the EQ() function to compare values in A1:A10 with values in B1:B10. The formula should return TRUE if the values are equal and FALSE otherwise.

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 EQ(). 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()

How to Make An Easter Egg Hunt in a Google Sheet - by BetterSheets.co

Create a pastel colored hunting game, just in time for Easter.

Intermediate

COUNTIF() IF()

Calculate ROAS in Google Sheets

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

Intermediate

CONCATENATE() ROUND()

What is this Ampersand Doing in Google Sheets?

What is "&" doing in this formula? MONTH(A1&1) Do you know why this is s...

CONCAT() DATE() MONTH() VALUE()

Unlock these tutorials

Learn more about the EQ() formula:

Generate a EQ() formula for your needs

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

Generate a EQ() formula