Md. Abdur Rahim Rasel
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.
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.
- 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.
- 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
- How to Put 0 in Excel in Front of Numbers (5 Handy Methods)
- Insert Tick Mark in Excel (7 Useful Ways)
- How to Type Delta Symbol in Excel (8 Effective Ways)
- Type Diameter Symbol in Excel (4 Quick Methods)
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
- 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.
Step 2:
- Hence, autoFill the summation sign(∫) to the rest of the cell in column E.
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
- 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.
- As a result, you will be able to insert a math equation with math symbols in cell E5.
Step 2:
- After that, repeat step 1 to insert the math equation with math symbols which has been given in the below screenshot.
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
- How to Put Sign in Excel Without Formula (5 Ways)
- Insert Degree Symbol in Excel (6 Suitable Methods)
- How to Insert Symbol in Excel Header (4 Ideal Methods)
- Insert Symbol in Excel Footer (3 Effective Ways)
- How to Add Symbol Before a Number in Excel (3 Ways)
- Insert Less Than or Equal to Symbol in Excel (5 Quick Methods)
