**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!