Back to Top A white circle with a black border surrounding a chevron pointing up. It indicates 'click here to go back to the top of the page.'

How to multiply cells and numbers in Microsoft Excel using 3 different methods

microsoft excel
You may want to multiply cells or numbers in Microsoft Excel to analyze data. Shutterstock

Advertisement

Multiplying values is one of the most frequently performed functions in Excel, so it should be no surprise that there are several ways to do this. 

You can use whichever method is best suited to what you are trying to accomplish in your spreadsheet on a Mac or PC

Here are a few of your simplest options to perform multiplication. 

Advertisement

Check out the products mentioned in this article:

Microsoft Office 365 Home (From $99.99 at Best Buy)

MacBook Pro (From $1,299.99 at Best Buy)

Lenovo IdeaPad 130 (From $299.99 at Best Buy)

Advertisement

How to multiply two numbers in Excel

The easiest way to do this is by multiplying numbers in a single cell using a simple formula. 

For example, if you type "=2*6" into a cell and press Enter on the keyboard, you should see the cell display "12."

multiply 1
The easiest way to multiply numbers is using the asterisk. Dave Johnson/Business Insider

You can also multiply two different cells together.

1. In a cell, type "=" 

2. Click in the cell that contains the first number you want to multiply. 

3. Type "*".

4. Click the second cell you want to multiply.

5. Press Enter. 

multiply 2
You can reference cells in a multiplication formula by clicking them. Dave Johnson/Business Insider
Advertisement

How to multiply cells and numbers using the PRODUCT formula

You aren't limited to multiplying just two cells — you can multiply up to 255 values at once using the PRODUCT formula. 

Using this formula, you can multiply individual cells and numbers by separating them with commas and multiply a series of cells with a colon. 

For example, in the formula "=PRODUCT(A1,A3:A5,B1,10)" — Excel would multiply (A1 x A3 x A4 x A5 x B1 x 10) because A3:A5 indicates that it should multiply A3, A4, and A5. 

Remember that the order of these cells and numbers is irrelevant in multiplication. 

Advertisement

How to multiply a column of values by a constant

Suppose you have a series of numbers and want to multiply each one of them by the same value. You can do that by using an absolute reference to the cell that contains the constant.

1. Set up a column of numbers you want to multiply, and then put the constant in another cell.

2. In a new cell, type "=" and click the first cell you want to multiply. 

3. Type the name of the cell that contains the constant, adding a "$" before both the letter and number. The dollar sign turns this into an absolute reference, so it won't change if you copy and paste it in the spreadsheet.

multiply 3
The $ is a powerful tool for referencing cells in a formula. Dave Johnson/Business Insider

4. Press Enter.

5. You can now copy and paste this to additional cells to perform the multiplication on the other numbers. The easiest way to do this is to drag the cell by its lower right corner to copy it. 

multiply 4
When you copy the formula down a column of numbers, you can multiply a set of numbers by a different set, or by a constant. Dave Johnson/Business Insider
Advertisement

Related coverage from How To Do Everything: Tech:

Insider Inc. receives a commission when you buy through our links.

Advertisement

Jump to

  1. Main content
  2. Search
  3. Account