- You can multiply in Excel using a few different methods.
- It's easy to multiply two numbers in Excel, but you can also multiply many different cells and numbers together, or multiply a column of values by a constant.
- Visit Business Insider's homepage for more stories.
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.
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)
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."
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.
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.
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.
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.
Related coverage from How To Do Everything: Tech:
How to merge and unmerge cells in Microsoft Excel in 4 ways, to clean up your data and formatting
How to lock cells in Microsoft Excel, so people you send spreadsheets to can't change certain cells or data
How to alphabetize data in an Excel spreadsheet by column or row, and by using shortcuts
How to embed a YouTube video into a PowerPoint presentation, depending on the version of your PowerPoint
Insider Inc. receives a commission when you buy through our links.