How to Insert Less Than or Equal to Symbol in Excel (5 Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

Dataset: Insert Less Than or Equal to Symbol in Excel


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.

Using symbol command to Insert Less Than or Equal to Symbol in Excel

❷ Select Mathematical Operators in the Subset box.

❸ Now click on the ‘less than or equal to’ sign.

❹ Then click Insert.

Inserting Less Than or Equal to Symbol in Excel

The sign will be attached to the selected cell.

Read More: How to Insert Greater Than or Equal to Symbol in Excel


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.

Using keyboard shortcut to Insert Less Than or Equal to Symbol in Excel

❹ 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.

Using Equation to Insert ‘Less Than or Equal to’ Symbol in excel

❸ Under the Equation tab find the ‘less than or equal to’ symbol.

❹ Double-click on it.

Using Equation to Insert ‘Less Than or Equal to’ Symbol in excel

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.

Applying Ink Equation to Insert ‘Less Than or Equal to’ Symbol in excel

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.

Insert ‘Less Than or Equal to’ Symbol Using Character Map in Excel

❽ 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.

Insert Less Than or Equal to Symbol in Excel


Download Practice Workbook

You can download the Excel file from the following link and practice along with it.


Conclusion

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.


Related Articles


<< Go Back to Mathematical Symbols in Excel | Insert Symbol in Excel | Excel Symbols | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mrinmoy Roy
Mrinmoy Roy

Mrinmoy Roy, a dedicated professional with a BSc in Electronics and Communication Engineering from Khulna University of Engineering & Technology, Bangladesh, brings over two years of expertise to the ExcelDemy project. As a prolific contributor, he has authored around 180 articles, showcasing his deep knowledge and passion for Microsoft Excel, Data Analysis, and VBA. His unwavering commitment to continuous learning, combined with versatile skills, renders him well-suited for roles in data management and spreadsheet solutions. He has interest... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo