"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:
Other People Are Reading
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.
Write “3” in cell A2. Press the “Enter” key. Write “1” in A3, and then press “Enter” again.
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.
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for