Sunday, February 12, 2023

How to Multiply in Excel

An easy-to-use guide to multiply numbers in Excel automatically


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.

[Edit]Steps

[Edit]Multiplying in a Cell

  1. Open Excel. It's a green app with a white "X" on it.
    Multiply in Excel Step 1 Version 5.jpg
    • You'll need to click Blank workbook (PC) or New and then Blank 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.
    Multiply in Excel Step 2 Version 5.jpg
  3. Type into the cell. All formulas in Excel start with the equals sign.
    Multiply in Excel Step 3 Version 5.jpg
  4. Enter the first number. This should go directly after the "=" symbol with no space.
    Multiply in Excel Step 4 Version 5.jpg
  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.
    Multiply in Excel Step 5 Version 5.jpg
  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 .
    Multiply in Excel Step 6 Version 5.jpg
    • 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. Press . 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.
    Multiply in Excel Step 7 Version 5.jpg

[Edit]Multiplying Cells

  1. Open an Excel presentation. Simply double-click an Excel document to open it in Excel.
    Multiply in Excel Step 8 Version 5.jpg
  2. Click a cell. Doing so will select it, allowing you to type into it.
    Multiply in Excel Step 9 Version 4.jpg
  3. Type into the cell. All formulas in Excel start with the equals sign.
    Multiply in Excel Step 10 Version 4.jpg
  4. Type in another cell's name. This should go directly after the "=" with no space.
    Multiply in Excel Step 11 Version 2.jpg
    • 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.
    Multiply in Excel Step 12 Version 2.jpg
  6. Type in a different cell's name. This will set the second variable in your formula as the second cell's value.
    Multiply in Excel Step 13 Version 2.jpg
    • 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. Press . This will run your formula and display the result in your selected cell.
    Multiply in Excel Step 14 Version 2.jpg
    • When you click the cell with the formula result, the formula itself will display in the Excel address bar.

[Edit]Multiplying a Range of Cells

  1. Open an Excel presentation. Simply double-click an Excel document to open it in Excel.
    Multiply in Excel Step 15 Version 2.jpg
  2. Click a cell. Doing so will select it, allowing you to type into it.
    Multiply in Excel Step 16 Version 2.jpg
  3. Type into your cell. This command indicates that you want to multiply items together.
    Multiply in Excel Step 17 Version 2.jpg
  4. Type in the first cell's name. This should be the cell at the top of the range of data.
    Multiply in Excel Step 18 Version 2.jpg
    • 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.
    Multiply in Excel Step 19 Version 2.jpg
  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.
    Multiply in Excel Step 20 Version 2.jpg
    • 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 press . 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.
    Multiply in Excel Step 21 Version 2.jpg
    • If you change the contents of a cell within the multiplication range, the value in your selected cell will also change.

[Edit]Video

[Edit]Tips

  • 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).

[Edit]Related wikiHows


[Edit]Quick Summary



from How to of the Day https://ift.tt/P6D71WN

No comments:

Post a Comment