How To Multiply In Excel In Office 2010

5.8 min read|Last Updated: February 15th, 2021|Categories: excel|
table of content

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 go over everything about multiplying in Excel. 

Note: When you use multiple operators to write a formula, observe the computational priority of these operators. Consider the term PEMDAS for this purpose.

  1.  Parentheses
  2. Exponentiation
  3. Multiply and Division
  4. Addition and Subtraction

Multiplication in Excel

Actually, doing multiplication in Excel is not that hard, it’s pretty simple, and we’re going to walk you through it.

To multiply your data in Excel, 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 techniques 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.