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 1Create 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 2Create 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 3Create 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 4Create 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 5Create 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 6Create 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 7Create and edit mathematical expressions in Excel Picture 7

- Similarly enter the formula for the remaining equation:

Create and edit mathematical expressions in Excel Picture 8Create 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 9Create 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 10Create 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!

4 ★ | 1 Vote