- Excel Tutorial
- Excel Introduction
- Excel Addition(+)
- Excel Subtraction(-)
- Multiplication(*)
- Excel Division(/)
- Excel IF Function
- Excel SUMIF
- Count & CountIF
- Excel IFerror
- Excel Pivot Table
- Move Pivot Tables
- Excel Drop-Down list
- Conditional Formatting
- Excel Hyperlink
- Excel Vlookup
- Excel Hlookup
- Excel Protect Sheet
- Excel Macros
- Excel Insert Images
- Excel Concatenate
- Excel Text To Column
- Remove Duplicates
- Excel Cell Formatting
- Group in Excel
- Excel Comments
- Excel Freeze Panes
- Excel Charts
- Print in Excel
- Excel Transpose
- Reminders in Excel
- Reduce Excel File Size
- Percentage in Excel
- Substitute Function
- RANK Function
- ROUND Function
- Cell References
- Date Function

EXCEL FORMULAS Excel Tutorial Excel Introduction Excel Addition(+) Excel Subtraction(-) Multiplication(*) Excel Division(/) Excel IF Function Excel SUMIF Count & CountIF Excel IFerror Excel Pivot Table Move Pivot Tables Excel Drop-Down list Conditional Formatting Excel Hyperlink Excel Vlookup Excel Hlookup Excel Protect Sheet Excel Macros Excel Insert Images Excel Concatenate Excel Text To Column Remove Duplicates Excel Cell Formatting Group in Excel Excel Comments Excel Freeze Panes Excel Charts Print In Excel Excel Transpose Reminders in Excel Reduce Excel File Size Percentage in Excel Substitute Function RANK Function ROUND Function Cell References Date Function

Multiplication | Examples | PRODUCT Function | Absolute Reference | Multiply Without Formula

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.

1.=(number1*number2)

2.=number1*number2*number3

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

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.

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

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

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.

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.

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.

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.

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

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.

4. Select Multiply in the Paste Special dialog box.

5. Click OK.

Result is:

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 Learn:

Tutorials in a simple Way.

Excel with downloadable samples.

HTML with sample website code.

PowerPoint presentations.

MS Word for offical use.