Use Less Than and Equal To Operator in Excel

puneet-gogia-excel-champs

- Written by Puneet

In Excel, you can use the less than equal to operator for a logical test (test a condition). You can combine the less than and equal to sign for this. In this tutorial, we will learn to use it in a formula.

less-than-and-equal-to-operator

Write a Formula using Less Than or Equal To

  • Enter an equal sign to start the formula.
  • Refer to the first cell where you have the values to test.
  • Type the less than and equal to (<=) using your keyboard.
  • Refer to the second cell where you have the value to test with.
  • Hit enter to get the result.
formula-using-less-than-or-equal-to

When you use the less than and equal to operator, you need to refer to the cell or enter the value you want to test, then the <= operator and the value or the cell with which you want to test it.

refer-to-cell

In the example, we have 3 to compare with the value 4 to check if it is less than or equal to. It returns TRUE in the result as 3 is lower than 4.

Using Only Lower Than <

And you can also use less than the operator as well. You can only test if the values are lower than the others. And by using the same example, you can write a single formula.

only-lower-than-operator

We have the same result here (TRUE), as 3 is a lower value than 4.

Last Updated: December 30, 2023