How to Perform Multiplication in Excel

Using the Excel * Operator

 AB
1= 4 * 3 * 10 
2  
3  

The easiest way to perform multiplication in Excel is to use the * operator, as shown in the above spreadsheet on the right. This formula consists of the = sign, followed by two or more numbers, separated by the * operator.

The simple Excel multiplication formula in the example spreadsheet multiplies the numbers 4, 3, and 10, and returns the result 120.


 AB
1= B1 * B2 * B34
2 3
3 10

As with all Excel formulas, instead of typing numbers directly into the formula, you can use references to cells containing numbers in your multiplication formula.

An example of how perform multiplication in Excel, using cell references, is shown in cell A1 of the above spreadsheet on the right. This formula multiplies the numbers in cells B1, B2 and B3 (i.e. the values 4, 3 and 10), and again, returns the value 120.


Using the Excel Product Function

Instead of using the * operator, as shown above, you can use the built-in Excel Product Function to perform a multiplication in Excel.

The format of the Excel Product function is:

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

where number1, [number2], etc. are one or more numeric values (or references to cells containing numeric values) that you want to multiply together.

 AB
1=PRODUCT( B1, B2, B3 )4
2 3
3 10

An example of the Excel Product function is shown in cell A1 of the above spreadsheet on the right.

In this example, the Product function is used to multiply the three values in cells B1, B2 and B3 (i.e. the values 4, 3 and 10).

Once again, the product of the three numbers is calculated to be 120.


Supplying a Range of Cells to the Product Function

You can also supply one or more ranges of cells to the Excel Product function (rather than typing in each individual value or cell reference).

For example, in the above example spreadsheet, in order to find the product of the values in cells B1-B3, you could simply type the formula:

=PRODUCT( B1:B3 )

This is much quicker than typing multiple cell references, particularly if you have a large set of values that you want to find the product of.

Further information and examples of the Excel Product function are provided on the Excel Product Function page.


Continue to the Excel Division page  >>