Excel can perform a variety of basic math functions, and the articles below will show you how to create the necessary formulas to add, subtract, multiply, or divide numbers. You will also learn to work with indicators and basic mathematical functions.
- How to subtract in Excel
- How to Split in Excel
- How to Multiply in Excel
- How to add to Excel
- How to change the order of operations in Excel
- Exhibitors in Excel
- Excel math functions
How to subtract in Excel
Topics covered:
-
How to subtract numbers with formula.
-
Step-by-step example of creating a subtraction formula in Excel using point and click.
-
Why using cell references makes it easier to update your calculations if your data ever changes.
How to subtract in Excel
How to Split in Excel
Topics covered:
-
How to divide two numbers using a formula.
-
Step-by-step example of creating a division formula in Excel using point and click.
-
Why using cell references makes it easier to update your calculations if your data ever changes.
How to Split in Excel
How to Multiply in Excel
Topics covered:
-
How to multiply two numbers with a formula.
-
Step-by-step example of creating a multiplication formula in Excel with a pointer and a click.
-
Why using cell references makes it easier to update your calculations if your data ever changes.
How to Multiply in Excel
How to add to Excel
Topics covered:
-
How to add two numbers using a formula.
-
Step-by-step example of creating a summation formula in Excel with the pointer and click.
-
Why using cell references makes it easier to update your calculations if your data ever changes.
How to add to Excel
How to change the order of operations in Excel
Topics covered:
-
The order of operations of these spreadsheet programs follows when calculating a formula.
-
How to change the order of operations in formulas.
Change the order of operations?
Exhibitors in Excel
Although less commonly used than the math operators listed above, Excel uses the caret character ( † ) as the exponent operator in formulas. Exponents are sometimes referred to as repeated multiplication because the exponent specifies how many times to multiply the base by itself.
For example, the exponent 4^2 (four squared) has a base of 4 and an exponent of 2 and is raised to the power of two.
In either case, the formula is a short form that says that the base must be doubled (4 x 4) to get the result 16.
Similarly, 5^3 (five cubes) indicates that the number 5 must be multiplied a total of three times (5 x 5 x 5), meaning 125.
Excel math functions
In addition to the basic math formulas mentioned above, Excel has several built-in formula functions that you can use to perform many math operations.
These features include:
-
Function SUM – adds columns or rows of numbers.
-
Function PRODUCT – Multiplies two or more numbers together. When you multiply just two numbers, the multiplication formula is simpler.
-
Function QUOTIENT – returns only the integer part (integer only) of the divide operation.
-
Function MOD Returns only the rest of the divide operation.