ExcelFunctions.net

Search Site:

A | B | |
---|---|---|

1 | = 4 * 3 * 10 | |

2 | ||

3 |

In order to perform multiplication in Excel you simply use the * operator, as shown in the example in the above 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 | = B1 * B2 * B3 | 4 |

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

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 of the above 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.