When you're dealing with complicated mathematical equations, trying to duplicate them in any Office program is a challenge. Excel is no exception. The symbols used in mathematical equations can often make it difficult to include them in a spreadsheet.
Fortunately, Excel offers a few common equations at the click of a button. These equations don't produce results the way that a traditional Excel formula does (they're just text boxes), but they allow you to display a mathematical equation correctly in a worksheet without spending hours hunting for symbols.
To insert a mathematical equation in your spreadsheet:
Open your workbook and go to the Insert tab.
In the Symbols group, click on the Equation button's dropdown arrow to view the dropdown palette of available common mathematical equations.
Select an equation from the palette to place a text box containing the equation in your worksheet.
If the equation you want to create isn't in the Equation button's dropdown palette, you can click the Equation button itself and open the Equation Editor. You'll see a contextual tab that allows you to quickly insert symbols and create structures (brackets, operators, fractions, etc).
No comments:
Post a Comment