Formula for Addition Subtraction Multiplication and Division in Excel

Addition, subtraction, multiplication, and division are of regular use in doing calculations on mathematics in Excel. This article will show how you can do these operations easily and quickly with function or formula, with suitable examples and proper illustrations.

Formula for Addition, Subtraction, Multiplication, and Division in Excel

There are some differences between the mathematical operator and the operators used in Excel. So, I am showing the operators of addition, subtraction, multiplication, and division in Excel in the table below.

Now, we will see each operation with some examples in the next sections.

1. Excel Formula for Addition

1.1  Using Basic Addition Formula

• To add the values of C5 and D5 you can simply write the formula with values:

• Otherwise, you can use a cell reference to write the formula. You can call a cell by either typing the cell column and row number or just clicking on the cell.

• If you use the cell reference, then you can copy the formula by CTRL + C and paste it to other cells by CTRL + V.

1.2 Using the SUM Function

• Another method to do addition in Excel is using the SUM function. To call the SUM function, you have to write ‘ =sum ’ in the cell. And there will open some suggestions. Then select the SUM function.

• Then inside the sum function, select the cells that will be added. Here I have done a horizontal addition using this formula:

• Similarly, you can do vertical addition using this formula:

• You can also call the SUM function from the ribbon menu. For this, at first click on the cell where you want to add values. Them go to the top ribbon, Press on the Formulas option. Then, select the AutoSum option, and there will open a drop-down menu. Select the SUM option.

• After pressing on the SUM option, you will see auto-suggestion selecting the cells. If the suggestion is correct, then press Enter.  If not then correct the cell references and press Enter.

Read More: How to Add and Then Divide in Excel

2. Subtraction Formula in Excel

• To subtract values, you can simply write this formula using the values:

• Also, you can use a cell reference to subtract values using this formula:

Using a cell reference is a good practice because it will allow you to copy and paste to other cells and will make you faster and more efficient. There is no subtract function in Excel.

3. How to Multiply in Excel

3.1  Using Basic Multiplication Formula

• To multiply in Excel, you have to use the asterisk ( * ) sign.  You can simply multiply values by writing this formula:

• You also can use the cell reference to multiply values. For this, you can write formula like this:

And using cell reference will allow you to copy and paste the formula to other cells.

3.2 Using the PRODUCT Function

• You can also do multiplication in Excel by using the PRODUCT function. For this, press on the cell where you want the result. Then write ‘=product’. There will come some suggestions. From them select the  PRODUCT option.

• After selecting the PRODUCT option, select the cells that you want to multiply and press Enter. 

Now you can copy the formula and paste it to other cells to do multiplication in a similar way.

4. Basic Mathematical Formula for Division

To divide values in Excel, the ‘ / ’ or forward dash sign is used. To divide values, you can simply write a formula like this mentioning the values:

• Also, you can call the cell references to divide values. For this, you write a formula like this:

Then you can copy and paste the formula to the other cells to do a similar division.

Read More: How to Divide in Excel for Entire Column

Additional Features for Division in Excel

Using QUOTIENT Function:

In the previous division calculation, you can see that the results are in fractional format. And there are some digits after the point. Often you want to have the result in the nearest integer value. Then you can use the QUOTIENT function.

• To call the QUOTIENT function, simply write ‘=quotient’ in the cells. And there will appear some suggestions. And Select the QUOTIENT  option.

• In the QUOTIENT  option, select the cell where the dividend value is and then select the cell of divisor value. Here, numerator stands for the dividend value and denominator stands for the divisor value.

• You can copy and paste the formula to other cells also to find the quotient values similarly.

Use the MOD Function to Find the Remainder:

Again, you may need to find the remainder after division sometimes. To find the value of the remainder, you can use the MOD function.

• For this just write ‘=Mod’ and there will appear suggestions and select the MOD function.

• Then, in the MOD function, at first, select the cell of dividend value then put a comma and then select the cell of divisor value. Then press Enter. 

• You can copy and paste the formula to other cells also to find the remainder values similarly.

Conclusion

We have to use the formula for addition, subtraction, multiplication, and division in Excel regularly doing any mathematical calculations. Beginners may find it difficult to find the ways to do addition, subtraction, multiplication, and division in Excel. So, in this article, I have tried to show the formulas and functions to do addition, subtraction, multiplication, and division in Excel.  I hope you found this article helpful. Please, drop comments, suggestions, or queries if you have any in the comment section below.

Related Articles

• [Fixed] Division Formula Not Working in Excel
• How to Divide a Number by a Percentage in Excel
• How to Divide with Decimals in Excel
• How to Divide for Entire Row in Excel
• How to Divide a Column by a Number in Excel
• How to Create a Division Formula in Excel
• Division Formula in Excel for Multiple Cells
• How to Divide One Column by Another in Excel
• How to Divide Without Using a Function in Excel
• Division Formula with Absolute Reference in Excel
• How to Divide a Group of Cells by a Number in Excel
• Division Formula with Absolute Reference in Excel
• How to Divide with Decimals in Excel