Formulas > =EQ()
How to Use EQ() in Google Sheets
Description
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.
Hints (2)
-
Remember to reference the correct cells in your formula.
-
You can drag the formula down to fill the rest of the cells in the range.
1 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()
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