How to Type Math Symbols in Excel (3 Easy Methods)

While working with Microsoft Excel, sometimes we need to deal with Mathematical symbols. We can easily type those Mathematical symbols in excel. Typing the math symbols in Excel is an easy task. This is a time-saving task also. Today, in this article, we’ll learn three quick and suitable ways to type math symbols in Excel effectively with appropriate illustrations.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Introduction to Math Symbols

Excel contains a standard set of arithmetic operators for performing addition, subtraction, multiplication, and exponentiation when composing formulae. Excel also has cell range operators, range intersects, and implicit intersection operators. The table below summarizes the symbols used in these processes.

Symbol Operation Example
+ Addition =12+8=20
* Multiplication =5*9=45
Subtraction =15-3=12
/ Division =12/6=2
() Parentheses =(2+6)/24
: Range =SUM(D5:D14)=155
@ Implicit intersection @D5:D14= 10
^ Exponentiation =2^3=8

3 Suitable Ways to Type Math Symbols in Excel

Let’s assume we have an Excel large worksheet that contains the information about several students of Armani School. The name of the students, the Identification Number, and the securing marks in Chemistry are given in Columns B, C, D, and E respectively. We can easily type math symbols in Excel by using the keyboard shortcuts, Symbol command, and Ink Equation command. Here’s an overview of the dataset for today’s task.

how to type math symbols in excel


1. Apply Keyboard Shortcuts to Type Math Symbols in Excel

Undoubtedly, keyboard shortcuts are the best method to type math symbols. We can easily type the mathematical symbols by using the keyboard shortcuts. This is an easy and time-saving task also. Let’s follow the instructions below to type math symbols!

Steps:

  • Let’s say, we will type the plus sign(+) by using the keyboard shortcut. To do that, first of all, select a cell. We will select cell E5 for the convenience of our work.

Apply Keyboard Shortcuts to Type Math Symbols in Excel

  • After selecting cell E5, press the Alt + 43 simultaneously on your keyboard.

  • Further, we will remark the chemistry marks as Plus sign(+) or Minus sign(-). The mark which is greater than 60 we will remark it as Plus sign(+) and the mark which is less than 60 we will remark it as Minus sign(-). For the Minus sign(-), press Alt + 45.

how to type math symbols in excel

  • Here some Alt code is given below.
Alt + Key Math Symbols Symbol Description
Alt + 43 + Plus Sign
Alt + 45 Minus Sign
Alt + 0247 ÷ Divide by / Division sign
Alt + 37 % Percentage Sign
Alt + 0137 Per mille (per thousand)
Alt + 60 < Less Than
Alt + 0215 × Multiplication Sign
Alt + 241 ± Plus or Minus
Alt + 240 Exactly Identical
Alt + 61 = Equals
Alt + 247 Approximately equal
Alt + 228 Summation
Alt + 62 > Greater Than
Alt + 242 Greater than or equal
Alt + 243 Less than or equal
Alt + 251 Square Root
Alt + 40 ( Open Bracket
Alt + 41 ) Close Bracket
Alt + 47 / Fraction Slash
Alt + 0188 ¼ Quarter
Alt + 0189 ½ Half
Alt + 0190 ¾ Three quarters
Alt + 46 . Decimal Point
Alt + 252 Power n
Alt + 0185 ¹ To the power of 1
Alt + 0178 ² squared
Alt + 0179 ³ cubed
Alt + 227 π Pi
Alt + 248 ° Degree sign
Alt + 35 # Number Sign
Alt + 236 Infinity
Alt + 230 µ Micro Symbol
Alt + 239 Suggest definition
Alt + 244 Top half
Alt + 245 Bottom Half
Alt + 8706 (W) Partial Differential
Alt + 8710 (W) Increment
Alt + 8719 (W) N-Ary
Alt + 8735 (W) Right Angle

Read More: How to Put Equal Sign in Excel without Formula (4 Easy Ways)


Similar Readings


2. Use Symbol Command to Type Math Symbols in Excel

Now, we will type the mathematical symbols by using the Symbol command. Let’s follow the instructions below to type math symbols!

Step 1:

  • First of all, select cell E5. Now, from your Insert tab, go to,

Insert → Symbols → Symbol

Use Symbol Command to Type Math Symbols in Excel

  • As a result, a dialog box named Symbol will appear in front of you. Form the Symbol dialog box, firstly, select the Symbols Secondly, select the Algerian from the Font drop-down box. Thirdly, select any mathematical sign. Let’s say, we select the summation sign(). At last, press Insert.

  • After pressing the Insert button, you will be able to type the summation sign() in cell E5.

Use Symbol Command to Type Math Symbols in Excel

Step 2:

  • Hence, autoFill the summation sign() to the rest of the cell in column E.

Use Symbol Command to Type Math Symbols in Excel

Read More: How to insert square root symbol in Excel (7 easy ways)


3. Apply Ink Equation Command to Type Math Symbols in Excel

Last but not the least, we will apply the Ink Equation command to type the math symbols. This is an easy and time-saving task also. Let’s follow the instructions below to type math symbols!

Step 1:

  • First, select cell E5. Now, from your Insert tab, go to,

Insert → Symbols → Equation → Ink Equation

Apply Ink Equation Command to Type Math Symbols in Excel

  • After that, a math Input Control dialog box pops up.

  • Now, type 5 + 3 = 8 in the written math here typing box. Hence, press the Insert option.

Apply Ink Equation Command to Type Math Symbols in Excel

  • As a result, you will be able to insert a math equation with math symbols in cell E5.

Step 2:

Apply Ink Equation Command to Type Math Symbols in Excel

Read More: How to Insert Greater Than or Equal to Symbol in Excel (5 Quick Methods)


Things to Remember

👉 To type the plus sign(+), you can press Alt + 43 simultaneously on your keyboard..


Conclusion

I hope all of the suitable methods mentioned above to type math symbols will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.


Related Articles

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo