How To Multiply In Excel In Office 2010

Share on facebook
Share on twitter
Share on pinterest

If you want to use the multiplication function in Excel and you don’t know how to do it, then you’re in the right place.

We are going to teach you everything about multiplying in Excel. 

Multiplication in Excel

Actually, doing multiplication in Excel is really easy, and we’re going to walk you through it.

To multiply your data in Excel, some different methods are available. 

To write a multiplication formula in Excel, just like any other function, you start with putting a “=” (equal) symbol in the formula bar. 

Multiplication function in Excel

If you type “=multiplication” in the formula bar in Excel, you’ll see that such a function isn’t available. But it doesn’t mean that you can’t use multiplication in Excel.

The multiply function in Excel is defined as “PRODUCT.”

In the following sections, we’ll see how to use the “PRODUCT” function to multiply numbers, cells, columns, and rows. 

Note that using “=PRODUCT” is not the only way to multiply numbers in Excel. And we’ll discuss other ways as well. 

Multiplication formula in Excel

Multiplication formula using (*)

In this formula, the asterisk (*) represents multiplication; for example:

“=6*8” 

multiplication in excel using asterisk

Multiplication formula using PRODUCT function:

in this formula “PRODUCT” represents multiply function; for example:

“=PRODUCT (6;8)”

multiplication in excel using product function

How to multiply cells in Excel?

As we explained before we can use either “PRODUCT” or (*) as the multiplication symbol.

Sometimes we enter numbers in the formula and sometimes we prefer to enter a cell. 

Let’s see how it’s done.

Multiplication with (*) and numbers

You can use the asterisk (*) to multiply as many numbers as you like:

For example, if you are willing to write a formula that multiplies 4,7,2, and 6; you should type:

“=4*7*2*6”. 

The result which is shown in the cell is 336.

You can use the asterisk (*) to multiply as many numbers as you like

 Multiplication with (*) and cells

If you want to write a formula that multiplies A1, A4, and B6; you should type:

“=A1*A4*B6” 

multiplication with asterisk and cells. A1*B1*D1

The result will be multiplication of the values in cells A1, A4 and B6.

To extend this formula, drag the cell down to the selected row.

  • You also can click on the selected cells while writing the formula, instead of typing the cell’s name.
  • To multiply a cell by a fixed number, just put the fixed number (for example 6) inside the equation:

“=6*A1*A4*B6”

Multiplication with PRODUCT function and numbers

PRODUCT function is actually a shortcut to writing multiplication formulas in Excel. 

Let’s consider the previous example again:

If you want to write a formula that multiplies 4,7,2, and 6; You can use PRODUCT function:

“=PRODUCT (4;7;2;6)” 

Multiplication with PRODUCT function and cells

To write a formula that multiplies A1, A4, and B6; you should type:

“=PRODUCT(A1*A4*B6)”

  • To multiply a range of data (for example A1, A2, A3, ans A4), you can easily type:

“=PRODUCT (A1:A4)”

multiply a range of data Product(A1:A6)
  • You can put any combination of, formulas, ranges, cells, and numbers in this formula; for example:

“=PRODUCT (4; A1:A16; D2:D9)”

You can multiply any combination of, formulas, ranges, cells, and numbers with the Product function

check out our other blogs, explaining the other three basic arithmetic operations in Excel:

Subscribe to our Newsletter

Share this post with your friends

Share on facebook
Share on google
Share on twitter
Share on linkedin

Leave a Reply

Your email address will not be published. Required fields are marked *