• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Write Equations in Excel

August 2, 2021 by Andrew Childress
Write Equations in Excel

Excel makes it easy to write equations in standard notation, making them helpful to all users. Let’s learn how to write equations in Excel.

Equations form the foundation of many mathematical and scientific applications. Many of these are commonly found inside Excel spreadsheets and projects. Excel makes it easy to write equations in standard notation, making them helpful to all users. Let’s learn how to write equations in Microsoft Excel.

How to Write Equations in Excel

While you can simply type basic equations in Excel cells, it becomes more challenging when you have complex notation of the type often found in advanced math. This is where it pays to use Excel’s built-in Equation menu. The Equation feature lets you type in equations, and automatically corrects them to match proper notation.

Imagine for a moment that you want to type in Albert Einstein’s classic theory of relativity, written as 𝑒=𝑚𝑐². If you simply typed into a single cell, you’d be left with e=mc2, which isn’t correct. The Equation feature helps you.

To write equations in Excel, begin by going to the Insert tab, found on the ribbon. On the right side, you’ll see the Equation option. Go ahead and click on it.

Write Equations in Excel

Excel will launch a new tab on the ribbon, called Equation. On it, you’ll see buttons to insert an array of complex notation: fractions, scripts, radicals, integrals, and many more.

You’ll also see a text box in the center of your spreadsheet, labeled Type Equation Here. Inside, you can input the equation of your choice. For this example, begin by typing e=. Both characters will automatically be formatted in equation style and italicized.

How to write equations in Excel

Continue with mc, then type ^2, then a space. Excel will automatically apply equation styling to the remaining characters, for an end result of 𝑒=𝑚𝑐².

Type equations in Excel

This feature works with equations long and short, simple and complex. It’s a great way to properly notate math and scientific equations right inside of your spreadsheets.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Add data bars in ExcelAdd Data Bars in Excel
Next Post:Sparklines in ExcelSparklines in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top