Table of Contents
The EQ function in Google Sheets is a powerful tool that allows users to compare two values and determine if they are equal. It takes two arguments, the first being the value that is being compared and the second being the value it is being compared to. The function will return a TRUE value if the two values are equal and a FALSE value if they are not. This function is useful for data analysis and can help users identify any discrepancies or similarities between two sets of data. By utilizing the EQ function, users can quickly and accurately compare values in their Google Sheets and make informed decisions based on the results.
EQ
Returns “TRUE” if two specified values are equal and “FALSE” otherwise. Equivalent to the “=” operator.
Sample Usage
EQ(A2,A3)
EQ(2,3)
Syntax
EQ(value1, value2)
value1– The first value.value2– The value to test againstvalue1for equality.
See Also
NE: Returns “TRUE” if two specified values are not equal and “FALSE” otherwise. Equivalent to the “<>” operator.
LTE: Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator.
LT: Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator.
GTE: Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator.
GT: Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator.
Examples
[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheets/d/1ahVQ2QYRDfJXMNkCFWOpShajCB6zbkdndLQF-h-f0MM/pubhtml” width=”500″]
Cite this article
stats writer (2024). How can I use the EQ function in Google Sheets to compare two values?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-eq-function-in-google-sheets-to-compare-two-values/
stats writer. "How can I use the EQ function in Google Sheets to compare two values?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-eq-function-in-google-sheets-to-compare-two-values/.
stats writer. "How can I use the EQ function in Google Sheets to compare two values?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-eq-function-in-google-sheets-to-compare-two-values/.
stats writer (2024) 'How can I use the EQ function in Google Sheets to compare two values?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-eq-function-in-google-sheets-to-compare-two-values/.
[1] stats writer, "How can I use the EQ function in Google Sheets to compare two values?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the EQ function in Google Sheets to compare two values?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.