While writing an equation or comparing numbers in Excel, we need to insert different types of symbols. Among all the symbols, less than or equal to a symbol is one of them. In this article, I will show you 5 quick methods to insert the less than or equal to symbol in Excel.
How to Insert ‘Less Than or Equal to’ Symbol in Excel: 5 Methods
In the following picture, Sara got A+ in her Biology. But her mark is unknown. But it is certain that her mark is more than equal to 80. I will represent this information with the ‘less than or equal to’ on the right side of her mark 80.
1. Symbol Command to Insert ‘Less Than or Equal to’
Excel has a huge collection of symbols under the Symbol command. I will use this command to insert the ‘less than or equal to’ sign.
❶ At first, select cell C7 and then go to Insert ➤ Symbols ➤ click on Symbol.
❷ Select Mathematical Operators in the Subset box.
❸ Now click on the ‘less than or equal to’ sign.
❹ Then click Insert.
The sign will be attached to the selected cell.
2. Insert Less Than or Equal to Symbol Using Keyboard Shortcut
There is a numerical code against each of the symbols in Excel. The numerical code for the ‘less than or equal to’ sign is 243.
To insert the symbol using the keyboard shortcut,
❶ Select a cell first.
❷ Then press and hold the ALT key.
❸ After that, type 243 using your keyboard.
❹ Now release the ALT key.
You will see that the symbol has already been inserted into your selected cell.
Read More: How to Add Symbol Before a Number in Excel
3. Using Equation to Insert ‘Less Than or Equal to’ Symbol
Here, I will show how to insert the ‘less than or equal to’ symbol in Excel using the Equation command.
❶ Select cell C7.
❷ Go to Insert ➤ Symbols ➤ Equation.
❸ Under the Equation tab find the ‘less than or equal to’ symbol.
❹ Double-click on it.
The symbol will be inserted in a separate moveable share.
❺ Drag the symbol into cell C7 after the number 80.
So, this is how we can separately insert the symbol into a cell in Excel.
Read More: How to Type Math Symbols in Excel
4. Applying Ink Equation to Insert Less Than or Equal to Symbol
The Ink Equation allows us to draw a symbol in Excel. Then it automatically recognizes the symbol that we drag. After that, it suggests the original symbol.
❶ Go to Insert ➤ Symbols ➤ Equation.
❷ With the Equation tab, go to Tool group ➤ Ink Equation.
❸ Math Input Control dialog box appears. Drag the ‘less than or equal to’ sign in the dialog box.
Excel will suggest you the original symbol.
❹ Just hit Insert to insert the symbol into your Excel sheet.
After inserting the symbol, you will find it in a moveable rectangular shape.
❺ Drag the symbol right after 80 in cell C7.
Read More: How to Insert Degree Symbol in Excel
5. Insert Less Than or Equal to Symbol Using Character Map
Finally, you can use the Character Map feature to insert the ‘less than or equal to’ symbol in Excel.
❶ Go to the Window Search Box.
❷ Then type Chapter Map.
❸ The Character Map will appear. Click on Open.
❹ The Character Map dialog box appears. Select Advanced View.
❺ Type ‘less than or Equal to’ in the Search for box.
❻ Then click Select.
❼ After that click on Copy to copy the symbol in the clipboard.
❽ Come back to cell C7 and put the cursor right after the number 80.
❾ Now press CTRL + V to paste the symbol into the cell.
Download Practice Workbook
You can download the Excel file from the following link and practice along with it.
To sum up, we have discussed 5 ways to insert less than or equal to sign in Excel. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries. Please visit our website to explore more.
- How to Insert Square Root Symbol in Excel
- How to Insert Sigma Symbol in Excel
- How to Put a Plus Sign in Excel without Formula
- How to Type Minus Sign in Excel Without Formula
- How to Use Multiply Sign in Excel
- How to Type Diameter Symbol in Excel