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)

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

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