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.

Did this summary help you?

Steps

Multiplying in a Cell

  1. 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, double-click it to open it in Excel.
  2. Click a cell.Doing so will select it, allowing you to type into it.
  3. Type=into the cell.All formulas in Excel start with the equals sign.
  4. Enter the first number.This should go directly after the "=" symbol with no space.
  5. 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.
  6. 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.
  7. 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

  1. Open an Excel presentation.Simply double-click an Excel document to open it in Excel.
  2. Click a cell.Doing so will select it, allowing you to type into it.
  3. Type=into the cell.All formulas in Excel start with the equals sign.
  4. 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.
  5. 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.
  6. 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.
  7. 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

  1. Open an Excel presentation.Simply double-click an Excel document to open it in Excel.
  2. Click a cell.Doing so will select it, allowing you to type into it.
  3. Type=PRODUCT(into your cell.This command indicates that you want to multiply items together.
  4. 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.
  5. Type:. The colon symbol (":") indicates to Excel that you want to multiply everything from the first cell through the next cell you enter.
  6. 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.
  7. 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

Search
  • Question
    How can I multiply two columns together?
    wikiHow Contributor
    Community Answer
    In 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!
  • Question
    How would I multiply 0.5 by a number, such as .50?
    wikiHow Contributor
    Community Answer
    In 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!
  • Question
    When I multiply two numbers, why do they disappear when the product shows up?
    wikiHow Contributor
    Community Answer
    Excel will only show the product. If you also want to see the numbers you multiplied, you will have to write them again.
    Thanks!
  • Question
    How do I multiply a number by a percentage?
    wikiHow Contributor
    Community Answer
    Use 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.25
    Thanks!
  • Question
    How 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 Contributor
    Community Answer
    If 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!
  • Question
    I want to multiply an empty cell with another, what is the formula?
    wikiHow Contributor
    Community Answer
    An 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!
Unanswered Questions
  • 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?
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
  • 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 (A1-A8, B1-B8, C1-C8, D1-D8).

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: 

Thanks to all authors for creating a page that has been read 574,495 times.
Is this article up to date?

About This Article

How helpful is this?
Co-authors:
Updated:
Views: 574,495

Anonymous

Jul 20

"After not using Excel for many years, this web page helped me remember and get me back on track. Thank you."
Rated this article:

Chaz Willis

Aug 8, 2019

"Recently-retired exec who has had really good admin assistants for years, and I needed refresher on formulas. Thiswas just right to jog my memory after many years of not having to prepare my own spreadsheets.





Video: Basic Excel Formulas - Add, Subtract, Divide, Multiply

How to Multiply in Excel
How to Multiply in Excel images

2019 year
2019 year - How to Multiply in Excel pictures

How to Multiply in Excel recommend
How to Multiply in Excel recommendations photo

How to Multiply in Excel photo
How to Multiply in Excel pictures

How to Multiply in Excel How to Multiply in Excel new pics
How to Multiply in Excel new picture

images How to Multiply in Excel
pics How to Multiply in Excel

Watch How to Multiply in Excel video
Watch How to Multiply in Excel video

Communication on this topic: How to Multiply in Excel, how-to-multiply-in-excel/
Communication on this topic: How to Multiply in Excel, how-to-multiply-in-excel/ , how-to-multiply-in-excel/

Related News


Boho Chic Outfit Ideas – 18 Ways to Dress Like Boho Chic
Meet The Kick-Ass Female British Playwrights Taking The Screen By Storm
How to Create a Permalink to a Single wikiHow Edit
How to Deal With Big Sisters
Bevespi Aerosphere
The Best and Worst Foods on the Benihana Menu
19 Sweet Short Wedding Dresses
How to Raise Mosquito Larvae for Fish Food
21 Ways to Pull Off Shorts at Work ThisSummer
Do you really need the doctor for that
Very Low Calorie Diet For Weight Loss – Safety, Benefits, Side Effects, And Diet Chart
Check out all of our Amazon Prime Day coverage
Testing Benefits 24 BADgal BANG vs. NYXs 8 Worth The Hype Mascaras
Dita Von Teese opens Harvey Nichols



Date: 06.12.2018, 05:13 / Views: 53495