How To Use Multiplication Formula In Excel Sheet
How to Multiply in Excel
Three Methods:
This wikiHow teaches you how to multiply numbers in Excel. You can multiply two or more numbers within one Excel cell, or you can multiply two or more Excel cells against one another.
Quick Summary
Two numbers in a cell:
1. Type=into a cell.
2. Type the first number.
3. Type*.
4. Type the second number.
5. PressEnterorReturn.
Two cells:
1. Type=into a cell.
2. Click the first cell value.
3. Type*.
4. Click the second cell value.
5. PressEnterorReturn.
Steps
Multiplying in a Cell

Open Excel.It's a green app with a white "X" on it.
 You'll need to clickBlank workbook(PC) orNewand thenBlank Workbook(Mac) to continue.
 If you have an existing presentation you'd like to open, doubleclick it to open it in Excel.

Click a cell.Doing so will select it, allowing you to type into it.

Type=into the cell.All formulas in Excel start with the equals sign.

Enter the first number.This should go directly after the "=" symbol with no space.

Type*after the first number.The asterisk symbol indicates that you wish to multiply the number before the asterisk with the number that comes after it.

Enter the second number.For example, if you first entered a 6, and wanted to multiply it by 6, your formula would now look like=6*6.
 You can repeat this process with as many numbers as you like, as long as the "*" symbol is between each of the numbers you want to multiply.

PressEnter.This will run your formula. The cell will display the product of the formula, though clicking the cell will display the formula itself in the Excel address bar.
Multiplying Cells

Open an Excel presentation.Simply doubleclick an Excel document to open it in Excel.

Click a cell.Doing so will select it, allowing you to type into it.

Type=into the cell.All formulas in Excel start with the equals sign.

Type in another cell's name.This should go directly after the "=" with no space.
 For example, typing "A1" into the cell sets A1's value as the first number in your formula.

Type*after the first cell name.The asterisk symbol indicates to Excel that you want to multiply the value before it with the value after it.

Type in a different cell's name.This will set the second variable in your formula as the second cell's value.
 For example, typing "D5" into the cell would make your formula look like this:=A1*D5.
 You can add more than two cell names to this formula, though you'll need to type "*" between subsequent cell names.

PressEnter.This will run your formula and display the result in your selected cell.
 When you click the cell with the formula result, the formula itself will display in the Excel address bar.
Multiplying a Range of Cells

Open an Excel presentation.Simply doubleclick an Excel document to open it in Excel.

Click a cell.Doing so will select it, allowing you to type into it.

Type=PRODUCT(into your cell.This command indicates that you want to multiply items together.

Type in the first cell's name.This should be the cell at the top of the range of data.
 For example, you might type "A1" here.

Type:. The colon symbol (":") indicates to Excel that you want to multiply everything from the first cell through the next cell you enter.

Type in another cell's name.This cell must be in the same column or row as the first cell in the formula if you want to multiply all the cells from the first cell to this one.
 In the example, typing "A5" would set up the formula to multiply the contents of A1, A2, A3, A4, and A5 together.

Type), then pressEnter.This last parenthesis closes the formula, and hitting enter runs the command and multiplies your range of cells together, displaying the result instantly in your selected cell.
 If you change the contents of a cell within the multiplication range, the value in your selected cell will also change.
Community Q&A

QuestionHow can I multiply two columns together?wikiHow ContributorCommunity AnswerIn another column, create a formula by entering =, then selecting the first value and typing * (which means multiply) before selecting the second value and pressing enter.Thanks!

QuestionHow would I multiply 0.5 by a number, such as .50?wikiHow ContributorCommunity AnswerIn any cell, you would simply enter = 0.5 * 37.5. As you leave the cell, the answer will be displayed. Alternatively, put 0.5 into cell A1 and 37.5 into cell A2. In cell A3, type = A1*A2. When you press Enter, the answer will be displayed.Thanks!

QuestionWhen I multiply two numbers, why do they disappear when the product shows up?wikiHow ContributorCommunity AnswerExcel will only show the product. If you also want to see the numbers you multiplied, you will have to write them again.Thanks!

QuestionHow do I multiply a number by a percentage?wikiHow ContributorCommunity AnswerUse the multiply a number by another number method, and change the percentage to a number. For example, 25% is 0.25 as a number. So to multiply 100 by 25% you would type in 100*0.25Thanks!

QuestionHow do I multiply a particular number written in one cell with various numbers mentioned in different cells, and show the result in a separate cell?wikiHow ContributorCommunity AnswerIf you have the other numbers in a row or a column, the easiest formula to apply would be PRODUCT(). Just select the range, and add the particular number you want to multiply them with after a comma. For example, if you have numbers in the range A1:A3 and that specific number in the cell C7, then type this formula in the cell you want the result: =PRODUCT(A1:A3,C7).Thanks!

QuestionI want to multiply an empty cell with another, what is the formula?wikiHow ContributorCommunity AnswerAn example for the formula of multiplication is "=A1*B1". You can just type the "=" symbol and click on one cell you want to multiply (e.g. A1) and add the "*" symbol and then click on the second cell you want to multiply (e.g. B1) and that's it!Thanks!

How do you write a formula to figure out "x times 10% = y" Where you have the value for y and want to calculate the value for x?

How do I multiply a column of numbers by 10% to another column

How do I multiply commands to take down all rows without an empty cell mark?

How do I multiply a number in excel which has error bars attached to it?

In Excel 2003, an entered number in the cell is automatically multiplied by 100. How do I get rid of this?
 When using the PRODUCT formula to calculate the product of a range, you can select more than just one column or row. For example, your range could be =PRODUCT(A1:D8). This will multiply all of the values of the cells in the rectangle defined by the range (A1A8, B1B8, C1C8, D1D8).
Related wikiHows
Article Info
Categories:
In other languages:
Italiano: , Español: , Português: , Deutsch: , Français: , 中文: , Русский: , Bahasa Indonesia: , Nederlands: , Čeština: , العربية: , ไทย: , Tiếng Việt:
About This Article
Anonymous
Jul 20
Chaz Willis
Aug 8, 2019
Video: Basic Excel Formulas  Add, Subtract, Divide, Multiply
Related News
Mademoiselle Ricci by Nina Ricci New Fragrance
Kate Middleton’s wardrobe makeover revealed
These 17 Newborn Babies Wearing Knitted Christmas Outfits Will Fill Your Heart With Cheer
How petroleum jelly helps to get rid of flaky lips scaly lips
8 Essential Healthy Cooking Tools
SpiceRoasted Acorn Squash
Women marry at 30
Peaches Geldof models for Ultimo
Pill without prescription
How to Add a Folder to Start Menu
This Month You Can Get Our September Issue For Just 1.99