Comparing values in Excel is a common task that can be done using comparison operators. This tutorial will cover the following comparison operators: equal to, greater than, less than, greater than or equal to, less than or equal to, and not equal to. We will also discuss using these operators in your daily Excel work.
Equal to Operator
- To find if two values are equal, you can use the equal to operator “=”.
- In the example below, we want to find out if the old price equals the new price.
- To do this, we can use the formula “=B2=C2” in cell D2, where B2 is the old price and C2 is the new price.
- This formula will return TRUE if the values in B2 and C2 are equal and FALSE if they are not. You can then drag the formula to find the values of other rows.
- You can then use this formula in an IF function to return a specific value depending on whether the comparison is TRUE or FALSE. Such as, if you want to return YES When the value is True and empty cell when FALSE, you can use the IF function this way: =IF(B2=C3, “YES”, “”)
Greater Than, Less Than, and Not Equal To Operators
- The greater than operator “>” can be used to find if one value is greater than another. (Example: “=B2>C2”)
- The less than operator “<” can be used to find if one value is less than another. (Example: “=B2<C2”)
- The not equal operator “<>” can be used to find if two values are not equal. (Example: “=B2<>C2”)
Greater Than or Equal To and Less Than or Equal To Operators
- The greater than or equal to operator “>=” can be used to find if one value is greater than or equal to another. (Example: “=B2>=C2”)
- The less than or equal to operator “<=” can be used to find if one value is less than or equal to another. (Example: “=B2<=C2”)
Conclusion
Comparing values in Excel can be done using comparison operators. These operators allow you to find if two values are equal, greater than or less than each other, and can be used in formulas and IF functions. Hope this article was helpful!
