SheetFX
≡
<< Go back to all functions

EQ

The EQ function in Google Sheets returns TRUE if two specified values are equal and FALSE otherwise. It is equivalent to the = operator. Use this function to compare values and perform conditional operations.

Function Syntax and Parameters

Syntax: EQ(value1, value2)

Parameters:

  • value1: The first value to compare.
  • value2: The second value to compare.

Step-by-Step Tutorial

  1. Using EQ to compare numbers:

    • Example: =EQ(5, 5)
    • Result: TRUE

  2. Using EQ to compare strings:

    • Example: =EQ("apple", "banana")
    • Result: FALSE

Use Cases and Scenarios

  1. Data Validation: Check if two input values match.
  2. Conditional Formatting: Highlight cells that have the same value.
  3. Filtering Data: Filter rows based on equality conditions.

Related Functions

  • NE: Returns TRUE if two specified values are not equal.
  • IF: Perform conditional operations based on a given condition.

Related Articles