A Tutorial of Excel Greater Than or Equal to Usage

Introduction

Often in Excel you'll need to do comparison of numbers to compute some sort of result. One of those common comparisons is to check if a number is Greater Than or Equal to another value. In this article we'll discuss this operator along with a few others and show some typical examples of their usage.

Prerequisites

  • You need a Microsoft Excel installed on your device
  • You must have knowledge of basic mathematical operations.

Excel formula greater than or equal to

This simply explains that in the formula of this function If the left operand is greater than the right operand then, the operator returns TRUE. Otherwise, it will returns False.

Greater than operator examples

Suppose we have the grades of the student as our given data.

Screenshot-of-sample-data.jpg

In the above table, we want to know if their grades are greater than 75. Thus, state the symbol of the operator greater than (>) and add the logic of 75.

Drag down to copy the formula into the remaining cells.

Screenshot-of-dragging-formula.jpg

As you notice, all the value greater than 75 returned into TRUE. This will be the basic concept of the excel operator symbols.

Logical operators will result either in TRUE or FALSE.

Greater than with IF condition

We can use the IF Function to test whether a cell has a value that is greater than the criteria specified. If the condition is met, the IF function returns TRUE otherwise, it returns FALSE.

The syntax for IF function is:

= IF(logical_test,[value_if_true],[value_if_false])

Using the same data in a previous example, we'll now identify if the grades of the students were passed or failed with a passing rate of 75.

Here is the step by step process:

Step 1: Start the formula with an equal sign (=) then, open IF condition.

Step 2: Enter the logical test =IF(B2>75,

Step 3: If the logical test is TRUE then, it would be "Passed".

Step 4: If the logical test is FALSE then, it would be "Failed".

-Excel-screenshot-of-if-function.jpg

Step 5: Drag and drop to copy the formula into the remaining cells.

Note: In IF condition you must supply double quotes to logical operators.

Greater than with SUMIF condition

Suppose we have this data and we want to know the sum of the sales if the value is >1000. To sum the values, we will use the SUMIF function.

Excel-screenshot-of-sumif-function.jpg

The syntax for sumif is:

SUMIF(range, criteria, [sum_range])

Here is the step by step process:

Step 1: Place the formula in any cell and start with an equal sign (=) followed by SUMIF function.

Step 2: Select the range of cells in the Total Sales column.

Step 3: Type the criteria ">"&1000

Step 4: Select the sum_range in Total Sales column.

Screenshot-of-sumif-result.jpg

The result for greater than an operator with SUMIF formula is 13500.

Greater than with COUNTIF condition

The syntax for countif function is:

=COUNTIF(range, criteria)

Suppose we have this data and you want to count the total sales that are greater than >500 from January to June.

Step 1: Start the formula with an equal sign (=) then, open the COUNTIF function.

Step 2: Select the range of cells from the Total Sales column.

Step 3: Enter the criteria ">"&500.

Step 4: Close the formula and press Enter.

Excel-screenshot-of-countif-function.jpg

So, the total number of greater than >500 sales is 2.

Note: In COUNTIF function you need to add double-quotes for logical operators.

Conclusion

We have gone over Greater than or equal to and some of the other numerica conditional operators in Excel. We hope you found this informative and you can apply it to your Excel worksheets.

Published: 
July 7, 2020
Author:
500 Rockets
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram