How to use the Less Than or Equal To function in Excel

Written by stephen byron cooper Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to use the Less Than or Equal To function in Excel
Use "<=" in an Excel function. (Microsoft Corporation)

"Equals," "less than" and "greater than" compare two values. Therefore, they cannot form part of any data entered into an Excel cell as mathematical operators while plus, minus, times and divide can. You can compare two values only as part of a formula in Excel, and as "less than" and "greater than" require quantities, they cannot be used to compare the Boolean values of TRUE and FALSE. The most frequent use of the "less than" or "equals to" operators is in an IF statement, which is implemented by a function in Excel.

Skill level:


  1. 1

    Open Excel with a new spreadsheet. Click in cell A1 and enter “2” (without the quotes here and throughout this aritcle). Press the “Enter” key.

  2. 2

    Write “3” in cell A2. Press the “Enter” key. Write “1” in A3, and then press “Enter” again.

  3. 3

    Click in cell B1. Enter the following formula: =IF(A1<=A2, “Less”, “More”)

    Press the “Enter” key. The field will show the word “Less” because the value in A1 is less than the value in A2.

  4. 4

    Click on B1, and then click on the small square in the bottom right corner of the frame. Drag the frame to include B2. This will copy the formula in B1 to B2, but with modifications for its position. The formula in B2 will be =IF A2<=A3, “Less”, “More”) The result that displays in the field will be “More” because A2 holds a higher value than A3.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.