Using Greater Than (>) and Equal To (=) Operator in Excel

puneet-gogia-excel-champs

- Written by Puneet

You can use the greater than and equal to the operator in Excel to test a logical condition.

  • Greater Than: >
  • Equal To: =
  • Greater Than or Equal To: (>=)
greater-than-equal-to-symbols

And in this tutorial, we will look at examples to understand this.

Write a Formula using Greater Than or Equal To

  1. Enter = in a cell to start the formula.
  2. Enter the first value or refer to the cell.
  3. Enter (>=).
  4. Enter the second value or refer to the cell.
  5. Hit enter to get the result.
formula-using-greater-than-and-equal-to

While using the greater than or equal to operator, you must first refer to the value you want to test. In the above example, we have tested 4, so we have referred to it first.

Only Greater Than (>)

The greater than the operator in Excel is what you use in your mathematical calculations. You can enter this operator from your keyboard. In the below example, you can see we have a condition to test if 4 is greater than 3, and in the result, we TRUE.

condition-to-test

And in the result, we have TRUE, which means the condition is TRUE 4 is greater than 3.

Only Equal To (=)

You can also test a condition only with (=) equal sign. So in the example below, we have (=4=3) where we test if 4 equals 3.

condition-to-test-with-only-equal-to

In the result, we have FALSE as 4 is not equal to 3.

Last Updated: March 24, 2024