How Can You Use Much less Than Or Equal To On Excel.
The lower than or equal to (<=) operator is used to check two gadgets in Excel. The operator sometimes returns a boolean worth till you create a distinct calculation primarily based on this situation. In Excel, you might use the lower than or equal to an operator to return totally different values in a number of methods.
Should you’re trying to make use of this operator in Excel, permit this text to be your information. On this article, we now have talked about a number of methods you might use the lower than or equal to the operator in Excel, so keep studying!
What Values Does the Much less Than or Equal to Return?
Universally, the lower than or equal to operator returns a boolean worth. A boolean worth is a knowledge kind that returns one in all two values: True or False.
Should you use a string knowledge kind (consisting of texts, numbers, and symbols) in your situation, the operator returns True or False relying on the worth you enter.
For numeric knowledge varieties, the operator returns a binary boolean worth. In case your situation is True, Excel returns the worth 1. Likewise, in case your situation is False, you’ll obtain 0 as your returned worth.
Nonetheless, it is very important do not forget that that is solely relevant in calculations. Should you examine the values by way of their worth, the returned worth continues to be True or False.
How Can You Use Much less Than or Equal to on Excel
The lower than or equal to operator is denoted by pairing the lower than (<) and equals to (=) signal. In Excel, you might use the operator to check after which calculate or format cells with Textual content, Quantity, and Date. Moreover, you might use the operator in built-in library Excel features like IF, AVERAGEIF, LEN, and SUMIF.
You would use the operator to check the size of two or more texts in several cells in your worksheet. If the size of the worth within the cell you’ve entered first is lower than or equal to the subsequent cell worth, the situation returns TRUE. Solely when the size of the worth referred within the first cell exceeds the second, Excel shows FALSE.
Listed here are cases the place the operator returns TRUE or 1:
- =“Apple”<= “Home”
- =“Apple”<= “Cucumber”
Within the first occasion, the size of each values is 5 characters lengthy, making them equal. This makes the situation true. Moreover, within the second case, the size of characters in Apple is lesser than that of cucumber, making the situation true once more.
Equally, right here is an instance when the operator returns FALSE or 0:
As we’ve already mentioned, the one time the operator returns False is when the primary worth’s character exceeds the latter’s size. On this case, the size of Apple is longer than that of Key. Therefore, the operator returns FALSE.
The lower than or equal to operator works with numeric knowledge varieties in two methods. Should you examine the values of two numbers, just like texts, the operator will return both True or False.
Listed here are the cases the place the lower than or equals to command will return TRUE or 1:
The quantity 10 is lower than 15 within the first instance, so this situation is true. Equally, within the second occasion, the quantity 10 equals 10. If this situation had been inserted in a calculation, the worth can be represented as 1.
For the operator to return FALSE or 0, your situation should look one thing like this
To state the apparent, the quantity 10 is neither lower than nor equal to 9. Subsequently, the operator returns FALSE or 0 within the case of numeric calculations.
You would additionally use the lower than or equals to signal (<=) whereas evaluating dates. Dates are saved as numbers and formatted in keeping with your system’s date format. So, any format you enter your date in shouldn’t be an issue whereas evaluating the values.
Keep in mind, the sooner the date is, the smaller its worth is in Excel. The lower than or equal to the operator will return a TRUE or FALSE boolean worth relying on the situation you’ve given.
You’ll get TRUE utilizing circumstances like the next:
Within the first occasion, the worth of eleventh August 2002 is lesser than the worth of 18th September 2022. Equally, the values of the dates talked about within the second occasion is identical. Subsequently, each cases return the TRUE boolean worth.
To get a FALSE or 0 worth, the circumstances should seem like this:
- =18-Sep-22 3:00PM <= 18-Sep-22
The primary occasion could appear pretty apparent; eleventh August 2002 comes earlier than 18th September 2022. Nonetheless, the second instance might increase a couple of eyebrows. If you enter a date with out mentioning the time, Excel information the time as 12:00AM. As 12 AM comes earlier than 3 PM, this situation is False.
You’ll be able to add the lower than or equal to operator on conditional features reminiscent of IF, AVERAGEIF, and SUMIF. Utilizing such conditional features, you may customise your returned worth relying on if the situation is TRUE or FALSE.
You need to use the IF operate to enter two outcomes relying on the character of your situation.
Firstly, you’ll have to specify standards which, if the situation meets, might be thought-about as TRUE and FALSE if it fails to take action. Then, separated by the comma signal (,), you’ll have to enter your boolean values; true adopted by false.
Comply with this format to enter the system with the IF operate:
=IF(standards, “end result if true”, “end result if false”)
Let’s say we’re calculating the gross sales of every month in a yr. The break-even quantity is $20,000. We may use the IF operate to find out if the corporate had a revenue or loss that month utilizing this system:
=IF(cell<= 20000, Loss, Revenue)
Excel has its personal operate to calculate the common of a knowledge set. Nonetheless, what if you might want to calculate the common solely whether it is underneath a sure quantity? In that case, you need to use the lower than or equal to operator with the AVERAGEIF operate.
Right here is the format you may seek advice from enter the system with the AVERAGEIF operate:
=AVERAGEIF(vary, standards, [average range])
You would use the lower than or equal to operator with the SUMIF operate to set standards for the referred cells to comply with to sum the info up.
Discuss with the next format to enter the SUMIF operate in a system:
=SUMIF(vary, standards, [sum range])
You would additionally use the lower than or equal to operator whereas making use of Conditional Formatting in your chosen cells. For instance, if you wish to spotlight all cells under a sure quantity, you might apply the lower than or equal to operator to format these cells.
Listed here are the steps you might refer to make use of the lower than or equal to signal to conditionally format your cells:
- Open your Excel workbook.
- Choose the cells with the worth.
- From the house tab, choose Conditional Formatting within the Types part.
- Head to New Rule.
- Underneath Choose a Rule Sort, choose Use a system to find out which cells to format.
- Enter your system underneath Format values the place this system is true on this format:
=cell <= (standards)
- Choose Format from the bottom-right nook of your display screen.
- Head to the Fill tab.
- Choose a colour and click on OK.
- Click on on OK once more.
Excel will format your cells in keeping with your criterion.
Check out more article on – How-To tutorial and latest highlights on – Technical News