How to insert math formulas in Excel

In the learning process, you often use MS Excel to calculate and process data. Because of some requirements that you need to insert mathematical formulas into Excel, but you do not know how to manipulate.

$How to insert math formulas in Excel Picture 1$

The article shows you how to insert math into Excel 2010, with Excel 2007 and Excel 2013 you can do the same.

Step 1: On the Excel interface, select the Insert tab and select Equation in the Symbol section to appear the mathematical formula insertion frame.

$How to insert math formulas in Excel Picture 2$

If not, you can use Excel built-in formulas when you select the small arrow icon next to Equation and select mathematical formulas.

$How to insert math formulas in Excel Picture 3$

Step 2: When you choose the frame for inserting mathematical formulas, on the Ribbon, the Design tab of Equation Tools appears . At this card you will be able to insert all mathematical formulas, mathematical symbols as you like.

$How to insert math formulas in Excel Picture 4$

You can combine many mathematical formulas together, no matter how complicated the mathematical formula, you can insert it in the Design tab .

Step 3: After you have inserted the mathematical formula, you can customize it to make the formula clearer and easier to see.

You can choose bold font style or large font size in the Font section of the Home tab .

$How to insert math formulas in Excel Picture 5$

The formula is inserted as a textbox so it is not in a cell, you can move the formula to the desired position by placing the mouse pointer on the edge of the formula frame. Then you hold and drag to the required position and release the mouse pointer.

How to insert math formulas in Excel Picture 6

Thus, you can insert mathematical formulas, from simple to more complex formulas into Excel spreadsheets without using any additional software. Good luck!

Kareem Winters

Update 19 May 2020

You should read it

May be interested

Instructions to use the Replace feature to reverse position words in Word
the replace feature in word you often know for the word substitution function commonly used to search and replace words in word. but in addition to the functions that you often use, replace also helps you reverse the position of words in word.
ISNA function in Excel
using excel documents shared from friends or on the internet, you sometimes come across isna () combined with other functions like vlookup () and if (). you wonder why they use isna () function so?
Instructions on how to draw organizational structure diagram in Word
to draw an organization chart in word you can use one of two ways: using smartart and using the shapes tool. using smartart will help you draw an organization chart faster than using the shapes tool.
How to write vertically, rotate text vertically in Word
according to some requirements, you need to write vertical letters in word, but you do not know how to write vertical letters? to be able to write vertically in word, there are many ways, you can refer to the ways guided in this article.
How to delete the underlined red mark in Word
the red, blue lines under the words in a word document are features to detect spelling and grammatical errors. but this feature does not apply to vietnamese, so when you type vietnamese with diacritics, a red dot will appear.
Warning of duplicate values in Excel - Warning of data duplication
microsoft excel gives you lots of useful features to help your data entry work best. one of those features is the duplicate value warning feature.

How to insert math formulas in Excel

You should read it

May be interested

Office information