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

In the following picture, Sara got an A+ in Biology, but her marks are unknown. However, an A+ means she has received at least an 80, which we’ll represent with a “less than or equal to” sign in the Marks cell.

## Method 1 â€“ Using the Symbol Command to Insert the â€˜Less Than or Equal toâ€™ symbol in Excel

• Select the cell you wish to add the â€˜Less Than or Equal toâ€™ symbol (in the example below, cell C7).
• Go to Insert, then toÂ Symbols, and select Symbol.

• Select the Mathematical Operators in the Subset box.
• Select the less than or equal toÂ sign.
• Click on Insert.

• The sign will be attached to the selected cell.

## Method 2 â€“ Using a Keyboard Shortcut to the Insert Less Than or Equal to Symbol in Excel

Each symbol in Excel has a numerical code, and the code for the â€˜less than or equal toâ€™ symbol is 243.

• Select a cell (in the example, that is C7).
• Press and hold the Alt key.
• Type 243 using your keyboard.

• Release the Alt key.

## Method 3 – Using Equations to Insert the â€˜Less Than or Equal toâ€™ Symbol in Excel

• Select the cell where you want to insert the symbol.
• Go to Insert, select Symbols, and choose 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 box.
• Drag the symbol into the cell where you need it (for the example, it’s to the right of the number).

Read More: How to Type Math Symbols in Excel

## Method 4 – Using the Ink Equation to Insert the Less Than or Equal to Symbol in Excel

• Go to Insert, select Symbols, and choose Equation.

• In the Equation tab, go to the Tool group and select Ink Equation.

• The Math Input Control dialog box will appear. Draw the less than or equal to sign within the dialog box. Excel will then suggest the original symbol.

• Excel puts the symbol in a moveable box.

• Drag the box next to the number within the cell you need.

Read More: How to Insert Degree Symbol in Excel

## Method 5 – Using The Character Map to Insert the Less Than or Equal to Symbol in Excel

• Go to the Window Search Box.
• Type Chapter Map into the Search Box.
• When the Character Map appears, click on Open.

• Type less than or Equal toÂ in the Search for box.
• Click Select.
• Click on Copy to save the symbol to your clipboard.

• Return to Excel and select the cell you need to input the sign in and place the cursor on the designated position.
• Press Ctrl + V to paste the symbol into the cell.

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
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

Advanced Excel Exercises with Solutions PDF