EQformula is a comparison operator that returns TRUE if the two provided values are equal and FALSE otherwise. This formula is commonly used in conditional statements and logical expressions.
EQ formula with the syntax shown below, it has 2 required parameters:
- value1 (required):
The first value to be compared.
- value2 (required):
The second value to be compared.
ExamplesHere are a few example use cases that explain how to use the
EQformula in Google Sheets.
Comparing two values
EQ formula can be used to compare two values and check if they are equal. For example, you can use this formula to compare the results of two different calculations.
EQ formula can be used in conjunction with conditional formatting to highlight cells that contain specific values. For example, you can highlight all cells that contain a certain word or phrase.
EQ formula can be used to filter data based on specific criteria. For example, you can use this formula to filter a list of products to only show those that are in stock.
EQnot working? Here are some common mistakes people make when using the
EQGoogle Sheets Formula:
One of the most common mistakes when using the EQ formula is using incorrect syntax. Make sure that you enter the formula with the correct syntax as indicated in the formula description.
Values are not equal
Another mistake is assuming that two values are equal when they are not. Make sure to check the values that you are comparing.
Wrong cell references
Make sure that you are referencing the correct cells when using the EQ formula. Incorrect cell references can lead to incorrect results.
The following functions are similar to
EQ or are often used with it in a formula:
IFformula is a logical function used to test a condition and return one value if the condition is true and another value if the condition is false. It is commonly used to create conditional statements and perform calculations based on certain conditions.
ANDfunction in Google Sheets is a logical function that returns TRUE if all of the logical expressions in the argument are TRUE, and FALSE if any of the logical expressions are FALSE. It can be used to test multiple conditions and evaluate whether they are all true or not.
ORformula is a logical formula that returns TRUE if at least one of the provided logical expressions is TRUE. It returns FALSE if all logical expressions are FALSE. This formula is commonly used in conjunction with other logical formulas, such as
AND, to build more complex logical statements.
NOTformula in Google Sheets is a logical function that negates a given logical expression. If the logical expression evaluates to TRUE, the formula returns FALSE, and vice versa. This function is commonly used to reverse the result of a logical test, or to check if a value is not equal to a specific criteria.
You can learn more about the
EQ Google Sheets function on Google Support.