Basic arithmetic in Excel
Formulas are the backbone of most advanced calculations within Excel. Think of a formula as an equation — it's a series of steps that lead to a final output. You can tell Excel that you're entering a formula in Excel by starting your input with the equals sign (
Since Excel sees the
Formulas in Excel use the standard mathematical
- Exponents (^)
- Multiplication (*)
- Division (/)
- Addition (+)
- Subtraction (-)
Take a look at the following equations, and see whether you can figure out how Excel arrives at the outputs specified:
8+ 4/ 4
8+ 4)/ 4
8+ 4^ 2
8+ 4)^ 2
Explore the 5 must-learn 'fundamentals' of Excel
Getting started with Excel is easy. Sign up for our 5-day mini-course to receive easy-to-follow lessons on using basic spreadsheets.
- The basics of rows, columns, and cells...
- How to sort and filter data like a pro...
- Plus, we'll reveal why formulas and cell references are so important and how to use them...