Excel Addition, Subtraction, Division And Multiplication Formulas

Table of Contents[Show]
Excel Addition, Subtraction, Division And Multiplication Formulas


How do you do addition, subtraction, multiplication and division operations in excel? One of the basic things that we need to master when learning Excel is doing the math operations of addition, subtraction, multiplication and division.

This has actually been touched on a little in a post about Microsoft Excel Calculation Operators. However, in the article the explanation is still general.

To perform subtraction and division, Office Excel does not provide special functions. In contrast to how to add data in Excel and multiply numbers, Excel provides the SUM, SUMIF, SUMIFS functions and others.

For more details, we will discuss one by one how to use Microsoft Excel formulas to add, subtract, multiply and divide as part of basic arithmetic operations.

Excel Addition Formulas

What is the addition formula in Excel? Here are some alternative ways you can add data in Excel.

The First Excel Addition Method

The most basic way to do additions in Microsoft Excel is to use the plus (+) operator or the plus symbol.

The method of writing the excel formula is the same as when we write general addition problems. Suppose we want to add up the numbers 130, 170, 110, 90,180 and 190 then we write the excel formula:


=130+170+110+90+180+190


The First Excel Addition Method

  

If you want to add numbers in an excel cell or range, for example, you want to add numbers in cells C2 to C7, then the excel formula for adding up is as follows:


=C2+C3+C4+C5+C6+C7

Second Excel Addition Method

Apart from using the plus (+) operator, addition in Excel can also be done using the SUM function provided by Office Excel.

The Excel addition formula using the SUM function is more often the choice of Excel users than using the plus (+) operator.

This method is simpler and more efficient if the cells to be summed are sequential and quite a lot.

For example, to add numeric data in the range D2 to D7 the excel formula used is:


=SUM (D2:D7)


For more details, consider the following picture.

Addition Excel formulas

  

Third Excel Addition Method

Apart from using the SUM function, Excel also provides several other functions to perform summations in Excel. Of course, with different characteristics and needs for each function.

Among the addition functions in Microsoft Excel, include:

  • SUMIF function

To add data based on a certain criterion or condition.

  • SUMIFS function

Used to add data based on more than one criterion or condition (Multiple criteria).

  • SUB-TOTAL

The subtotal function can be used to add visible data only (ignores hidden rows).

  • SUMPRODUCT

Used to add the product of the specified arguments

  • COUNT

To find out a lot of numeric (non-text) data

  • COUNTA

To find out the number of nonblank cells in a data range.

  • And other excel functions.

How to use the Microsoft Excel formula is to write an equal sign (=) to start each Excel formula writing.

Excel Subtraction Formulas

How do I do a subtraction in Excel?

How to use Microsoft Excel to reduce data values ​​is to use the minus operator (-).

Excel does not provide special functions such as addition formula with SUM function. Why is that? I do not know. hehehehe.

How to use the subtraction formula in Excel is quite simple, like writing a subtraction problem. It's just that at the beginning of the formula you must give an equal sign (=), this is a sign that what we are writing is an excel formula / formula. This is true in writing any excel formula.

For example, to reduce the number 130 from the number 70 the excel formula is:


=130-70


To reduce the numbers in certain cells, for example cell C2 minus the number value of cell D2, the excel formula for subtraction is as follows:


=C2-D2


Consider the following example of a subtraction excel formula in cell E2:

Excel Subtraction Formulas

 

How? Easy right? If you still have problems with the excel subtraction formula, you can tell it in the comments column provided.

Next we will learn about multiplication and division formulas in Excel.

Excel Multiplication Formulas

What is the multiplication formula in Excel? Multiplication operations using Microsoft Excel can be done in the following ways.

The First Excel Multiplication Method

The first way to do multiplication in Excel is to use the asterisk operator (*).

For example, to multiply numbers 2 and 3, the multiplication formula is:


=2*3


Another example of the excel multiplication formula between cells with an asterisk, for example, to multiply cell C2 by D2 as in the following figure, the excel formula used is:


=C2*D2

Excel Multiplication Formulas

 

In practice, you don't need to enter the formula manually in each cell under Cell E2. After entering the multiplication excel formula in Cell E2, you can simply copy and paste the other cells below it.

You can learn more about how to copy and paste in Excel on the following page: Guide to Copy Paste in Excel.

How to Multiply the Second Excel

Microsoft Excel also provides a special function for multiplying data, namely by using the PRODUCT function.

For example, to multiply cells C2 and D2 in the previous example you can also use the following multiplication excel formula:


=PRODUCT (C2:D2)


After knowing how to multiply in Excel, then how do you divide numbers in Microsoft Excel?

Excel Division Formulas

What is the number division formula in Excel?

To do simple division in Excel, use the slash operator (/).

How to use it to divide numbers in Excel formulas is the same as the previous methods.

For example, to divide cell A1 by Cell A2, the dividing formula you can use is as follows:


=A1/A2


Note that a number cannot be divided by zero (0). In Excel if something like this happens it will generate an error value # DIV / 0.

As we should know, Excel follows international rules in terms of calculations so that the placement of brackets "()" will also affect the calculation results in addition, subtraction, multiplication and division.

If the explanation above is still unclear regarding the method or addition formula, subtraction formula, multiplication formula or division formula in Excel, please submit it in the comments column at the bottom of this tutorial.

That is what I can share this time, hopefully it will be useful and increase our knowledge in using Microsoft Excel as a beginner like me. Greetings Excel Class.

Before leaving, don't forget to bookmark and share this excel tutorial article with the buttons provided below. Greetings Excel Class.

Leave a Comment