| Be My Friend

Formula For Multiplication In Excel | Excel Multiply Formula

Multiplication | Syntax | Examples | PRODUCT Function | Absolute Reference

Formula for Multiplication in Excel - There is no 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 Syntax:

1. =(number1*number2)

2. =number1*number2*number3

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

Excel Multiplication Examples:

In the below given examples, we will discuss different ways to do multiplication formula on Excel. 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.

Multiply Numbers in Cell

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 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.

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

After watching the video you can download a sample sheet and it helps you to do practice more. Please subscribe for more videos on our youtube channel. if you like our tutorial please share our Facebook and Youtube Videos.


To Get FREE Excel Shortcut Keys
       



Previous

Next

Why basictutorials.in ?

* To Learn Tutorials in a simple Way.

* To Learn Excel basics with downloadable samples.

* To Learn HTML with sample Website code.

* To Learn PowerPoint presentations.

* To Learn MS Word for offical use.