Formula For Multiplication In Excel

Formula for Multiplication in Excel - There is no direct multiplication formula in Excel.

Multiplication in Excel is used to multiply the cell numbers in columns or rows as same as a calculator.

In Excel, you can multiply the number of cells as per your requirements. using an asterisk (*) arithmetic operator sign or using PRODUCT function in Excel, we can multiply numbers in Excel.

In the previous Excel Subtraction tutorial, we have already discussed how to use arithmetic operator sign to do subtraction in Excel.

In the same way, you can use an asterisk (*) sign to do multiplication in Excel.

with the help of the below examples, you can easily understand the multiple ways to do multiplication in Excel.

Multiplication Formula:



3.=PRODUCT(number1, [number2], ...)

How to do Multiplication in Excel

In the below given examples, we will discuss how to multiply in excel in different ways. like how to multiply columns in Excel, PRODUCT function, How to Multiply in the same cell, etc.

1. Multiplication of more than one number in the same cell.

In this below example, in cell A1, three numbers are multiplied using an asterisk (*) arithmetic operator.

Formula for multiplication in excel

And the answer is 18. if you multiply the same numbers from separate cells also you will get the same answer.

2. How to multiply two columns in Excel?

In this example, the Total Book Value in cell E7 is multiplied using cell numbers D7 and C7. which means if you change numbers in D7 or C7 the value in E7 will change automatically. and the cell E7, depends on cell D7 and C7.

How to Multipy Columns in Excel

3. PRODUCT Function

In the above two examples, we did multiplication in Excel. but if you have more cells to multiply, it is difficult to select one by one.

Using PRODUCT function in Excel, it is easy to multiply range values. Let's take the below example.

Using PRODUCT function, we have multiplied the range of cells A1:A6.

Product Function

3.1 Let's take one more example of the PRODUCT Function. in this example, we have multiplied more than two ranges.

And the result of this i.e 622080, is equal to individual cell Multiplication.

Product Function Example

4. Using Absolute Cell Reference

Using absolute cell reference also we can do Multiplication in Excel.

In the below example, we have used " $ " absolute reference at C8 cell. to get Total Books Value, we need to multiply the MRP of each Book and Total Books. here MRP of each book is the same or fixed while doing multiplication.

Absolute Reference

If you add " $ " absolute reference it freezes that cell. in this example, it freezes the cell C8 for each multiplication with Total Books.

5. Multiply in Excel without using formula

Without using a formula also, you can multiply numbers in Excel.

In the below given example, we have two values in the cell G1 and H1.

Follow the below given steps:

1. First Select the cell G1 and copy the cell.

2. Select the cell H1, and then right click with the mouse.

3. Using shortcut or mouse open Paste Special dialog box.

Multiply Without Using Formula in Excel

4. Select Multiply in the Paste Special dialog box.

Paste Special Dialog Box

5. Click OK.

Result is:

Multiply Without Using Formula in Excel Result

Before starting any Formula or Function in Excel you need to add (=)


Get Your FREE Excel Shortcut Keys e-BOOK