How to use greater than or equal to in excel
Microsoft Excel offers a very interesting way to use greater than or equal to operator in excel. We can then perform the below mentioned way to use greater than or equal to operator in excel:
We’ll learn about this methodology step by step.
Greater than or equal to in excel:
Step-1: Excel with some numbers in 2 columns
To do this yourself, please follow the steps described below;
– Open the desired Excel workbook, and make sure there are some numbers in 2 columns to use the greater than or equal to operator.
Step-2: Typing the relevant formula
– Now as shown in the image above, type the formula “=’Number 1’>=’Number 2’, and hit enter.
Step-3: Getting the result
– Now since 10 is greater than 5, we get “TRUE” as our result. We may try to drag the formula for all the rows to get the result for all the rows.
Final Image: Getting the result for all the rows
– We are able to see that greater than or equal to operator is working fine for the selected range of numbers in our number grid.