Use basic math formulas, such as addition and subtraction in Excel

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.

Contents
  1. How to subtract in Excel
  2. How to Split in Excel
  3. How to Multiply in Excel
  4. How to add to Excel
  5. How to change the order of operations in Excel
  6. Exhibitors in Excel
  7. 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.

Leave a Reply

Your email address will not be published.