TipsMake

Create and edit mathematical expressions in Excel

Show you how to create and edit mathematical expressions in Excel. To insert mathematical formulas, you perform the following steps: Step 1: Go to the Insert - Text - Symbols - Equation tab: Step 2: The dialog box contains the display formula types - select the formula type

The following article provides detailed instructions for you to create and edit mathematical expressions in Excel.

Create and edit mathematical expressions in Excel Picture 1

To insert a mathematical formula, follow these steps:

Step 1: Go to the Insert tab -> Text -> Symbols -> Equation:

Create and edit mathematical expressions in Excel Picture 2

Step 2: The dialog box containing the formula types is displayed -> select the type of formula you want to create:

Create and edit mathematical expressions in Excel Picture 3

Step 3: After selecting the formula type -> the screen shows the formula you want to create:

Create and edit mathematical expressions in Excel Picture 4

Step 4: Edit the content of the formula according to your needs:

Create and edit mathematical expressions in Excel Picture 5

Step 5: In case you want to edit the formula in another way, do the following: Click on the formula -> Design -> Structures to select the formula type as you like:

Create and edit mathematical expressions in Excel Picture 6

Step 6: After selecting the fraction type -> enter the formula to get the results:

Create and edit mathematical expressions in Excel Picture 7

- Similarly enter the formula for the remaining equation:

Create and edit mathematical expressions in Excel Picture 8

Step 7: Edit the formula. If your formula is too small or you want to customize the color of the formula content, do the following: Select the content of the formula -> go to the Home tab in the Font dialog box to select the font, font size and color for the formula:

Create and edit mathematical expressions in Excel Picture 9

- So just a few simple operations you have created mathematical formulas:

Create and edit mathematical expressions in Excel Picture 10

The above is a detailed guide on how to create and edit mathematical expressions in Excel 2013.

Good luck!

Discover more

Jessica Tanner

Share by

Jessica Tanner
Update 19 May 2020