How to Perform Multiplication in Excel


Using the Excel * Operator

In order to perform multiplication in Excel you simply use the * operator, as shown in the example in the spreadsheet on the right. This formula, consists of the = sign, followed by two or more numbers, separated by the * operator.

This simple Excel multiplication formula multiplies the numbers 4, 3, and 10, and returns the result 120.

  A B
1 = 4 * 3 * 10  
2    
3    

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 numbers that are stored in cells, is shown in cell A1 of the spreadsheet on the right. This formula multiplies the numbers in cells B1, B2 and B3, and again, returns the value 120.

  A B
1 = B1 * B2 * B3 4
2   3
3   10

Using the Excel Product Function

Instead of using the * operator, as shown above, you can use the built-in Product function to perform a multiplication in Excel. This function is called by entering the following into an Excel cell:

=PRODUCT( number1, [number2], ... )
  A B
1 =PRODUCT( B1, B2, B3 ) 4
2   3
3   10

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

Cell A1 the spreadsheet on the right shows an example of the Excel Product function, used to multiply the three values in cells B1, B2 and B3. Again, the formula returns the value 120.

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

Return to the Excel Formulas Page

Return to the ExcelFunctions.net Home Page

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net