Let Excel be your calculator. This video shows you how to add, subtract, multiply, and divide in your workbook.
Want more?
Let Excel be your calculator.
With a simple formula, Excel can perform calculations on numbers using operators, such as the + sign, and functions, such as SUM.
To add numbers, you use the + sign.
A formula always starts with an = sign.
If I, then, type a number, a + sign, another number, and then press Enter, the cell displays the results.
You can add many numbers this way, not just two.
Instead of typing numbers in a formula, you can reference cells that contain numbers to make adding a bit easier and more flexible.
A4 is equal to 6, A5 is equal to 3.
I'll create a formula that adds the cells.
As with all formulas, I start again with the = sign, click a cell, type a + sign, then another cell, and press Enter.
And if I change a number in a cell, the result of the formula automatically updates.
When you double-click a cell, you can see right in the cell if it is a formula, like A6, or a number, like A4, or you can click a cell and look up here in the Formula Bar.
Subtracting is similar to adding, except you use the - sign.
Click a cell, then a - sign, then another cell, and press Enter.
Multiplying is similar to adding or subtracting, except you use an *.
Don't use an X for multiplying; that won't work.
Click a cell, then an *, then another cell, and press Enter.
Dividing is similar to multiplying, except you use a /.
Click a cell, then a /, then another cell, and press Enter.
Up next, Using functions.
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
