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

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.

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.

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 was selected). Then go to Insert ➤ Symbols ➤ Select Symbol.

❷ Select the Mathematical Operators in the Subset box.

❸ Select the ‘less than or equal to’ sign.

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

To insert the symbol using the keyboard shortcut complete the following steps.

❶ Select a cell first (in the example the selected cell is C7).

❷ Press and hold the ALT key.

❸ While holding the ALT key, type 243 using your keyboard.

(As shown in the example below).

❹ Release the ALT key.

The symbol has been inserted into your selected cell.

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 (in the example the cell is C7).

❷ Go to Insert ➤ Symbols ➤ Equation (as shown in the example below).

❸ 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 to the right of the number (in the example below the number is 80 within cell C7).

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

The Ink Equation feature enables us to draw a symbol in Excel, which is then automatically recognized. Subsequently, it suggests the original symbol.

❶ Go to Insert ➤ Symbols ➤ Equation (as shown in the example below).

❷ Using the Equation tab, go to Tool group ➤ Ink Equation (as shown in the example below).

❸ The Math Input Control dialog box will appear. Drag the ‘less than or equal to’ sign within the dialog box. Excel will then suggest the original symbol.

❹ Select Insert to add the symbol to your Excel sheet (as shown in the example below).

After inserting the symbol, locate it in the moveable box.

❺ Drag the symbol to the right of the number within the designated cell (in the example below the number is 80 within cell C7).

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 Window Search Box.

❸ When the Character Map appears. Click on Open (as shown in the example below).

❹ Select Advanced View.

❺ Type ‘less than or Equal to’ in the Search for box.

❻ Click Select.

❼ Click on Copy to save the symbol to your clipboard (as shown in the example below).

❽ Return to the selected cell (cell C7 in this example) and position the cursor to the right of the number (number 80 in this example).

❾ Press CTRL + V to paste the symbol into the cell (as shown in the example below).

Download Practice Workbook

You can download the Excel file from the following link to practice.

Less Than or Equal to Symbol.xlsx

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

Get FREE Advanced Excel Exercises with Solutions!