Tips about multiply in excel

Author:Alice | TIME:November 15,2017

The tutorial explains how to multiply in Excel by using the multiplication symbol and functions, how to create a formula for multiplying cells, ranges or entire columns, how to multiply and sum, and more.


While there is no universal multiplication formula in Excel, there exist a few different ways to multiply numbers and cells. The below examples will teach you how to write a formula best suited for your specific task.


Multiply a column of numbers by a constant number

Suppose you want to multiply each cell in a column of seven numbers by a number that is contained in another cell. In this example, the number you want to multiply by is 3, contained in cell C2.


Type =A2*$B$2 in a new column in your spreadsheet (the above example uses column D). Be sure to include a $ symbol before B and before 2 in the formula, and press ENTER.

NOTE: Using $ symbols tells Excel that the reference to B2 is "absolute," which means that when you copy the formula to another cell, the reference will always be to cell B2. If you didn't use $ symbols in the formula and you dragged the formula down to cell B3, Excel would change the formula to =A3*C3, which wouldn't work, because there is no value in B3.

Drag the formula down to the other cells in the column.

NOTE: In Excel 2016, the cells are populated automatically.


How to multiply numbers in Excel

To make the simplest multiplication formula in Excel, type the equals sign (=) in a cell, then type the first number you want to multiply, followed by an asterisk, followed by the second number, and hit the Enter key to calculate the formula.

For example, to multiply 2 by 5, you type this expression in a cell (with no spaces): =2*5

As shown in the screenshot below, Excel allow performing different arithmetic operations within one formula. Just remember about the order of calculations (PEMDAS): parentheses, exponentiation, multiplication or division whichever comes first, addition or subtraction whichever comes first.


How to multiply cells in Excel

To multiply two cells in Excel, use a multiplication formula like in the above example, but supply cell references instead of numbers. For example, to multiply the value in cell A2 by the value in B2, type this expression:


To multiply multiple cells, include more cell references in the formula, separated by the multiplication sign. For example:



How to multiply columns in Excel

To multiply two columns in Excel, write the multiplication formula for the topmost cell, for example:


After you've put the formula in the first cell (C2 in this example), double-click the small green square in the lower-right corner of the cell to copy the formula down the column, up to the last cell with data:


Due to the use of relative cell references (without the $ sign), our Excel multiply formula will adjust properly for each row:


In my opinion, this is the best but not the only way to multiply one column by another. You can learn other approaches in this tutorial: How to multiply columns in Excel.

Featured Deals

Related Articles

Get Featured Ringtones, Videos and Wallpaper from FunForMobile
SMTP Settings for Windows Live Hotmailcom Email Address
Top 5 Websites to Download Free Ringtones for Android and iPhone
What if i forgot apple id password
Track and change location with Wechat on iPhone
How to Fix Preparing SD Card Error Stuck on Android
How to Recover Deleted Facebook Messages on Android?
How to Fix Process COM Android MMS Has Stopped Error on Android?
Practical Solutions to Kik Login & Operation Issues