HomeApplicationOffice informationCreate and edit mathematical expressions in Excel

Create and edit mathematical expressions in Excel

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!

4 ★ | 1 Vote

You should read it

May be interested

  • Create and edit Textbox in ExcelPhoto of Create and edit Textbox in Excel
    instructions on how to create and edit textbox in excel. to insert textbox you perform the following steps: step 1: go to the insert - text - textbox tab: step 2: drag and move the mouse to create the area for textbox - enter the content to create textbox.
  • Insert and edit Word Art in ExcelPhoto of Insert and edit Word Art in Excel
    instructions on how to insert and edit word art in excel. step 1: go to the insert - text - word art tab - select the type of font you want to create word art: step 2: enter the content to create artistic text.
  • Data filtering (Data Filter) in ExcelPhoto of Data filtering (Data Filter) in Excel
    instructions on how to filter data in excel. 1. simple data filtering 1 condition. step 1: select the data you want to filter - data - filter - the data column appears arrow containing the options: step 2: if you want to filter by a certain value, do the following: uncheck select a
  • How to enter formulas in ExcelPhoto of How to enter formulas in Excel
    how to enter formulas in excel. to enter a formula in excel, you must start with the equal sign or excel will interpret it as a string. to enter the formula do the following: step 1: type the equal sign at the position of the cell to calculate according to the formula. step 2: enter the clutch
  • Familiarize yourself with PivotTable reports in ExcelPhoto of Familiarize yourself with PivotTable reports in Excel
    familiarize yourself with pivottable reports in excel. what are pivottable reports? - pivottable reports are the most useful feature of excel that helps you to statistic data according to many different criteria. from there, you save time and effort to produce a spending report
  • Filter PivotTable report data in ExcelPhoto of Filter PivotTable report data in Excel
    teach you how to filter pivottable reports data in excel 2013 accurately and quickly. the original pivottable report created on demand helps you see the entire information of the data. in case you want to statistically follow a field

Office information