+5 votes
85 views
in Office by (242k points)
reopened
Excel: Multiplying Numbers and Cells

1 Answer

+3 votes
by (1.6m points)
 
Best answer

This is how number multiplications work
1st step
2nd step
This is how multiplication with cell references works
1st step
2nd step

In this article we will explain to you how you can easily multiply with a formula in Excel..

image image

Excel offers many functions for data acquisition and processing, which is why multiplications are of course also possible. This works with formulas that you can insert directly into a table, for example. You can either multiply numbers directly or use cell references. You can find out exactly how this works in this guide.

This is how number multiplications work

1st step

image
In Excel, click on the cell in which you want the result to be displayed and type an " = " sign. Enter the first number that is to be multiplied, then a " * " sign and then the next number . If you would like to multiply more than two numbers, enter them one after the other , separated by a " * " sign. Your formula should look like this at the end, for example: " = 12 * 12 * 15 ".

2nd step

image
Confirm with [Enter] . You will now see the result in the cell. If you want to edit the formula, double-click the cell with the result and make the changes.

This is how multiplication with cell references works

Alternatively, you can work with cell references, for example if you want to multiply the values ​​in a table without entering them all manually.

1st step

image
In Excel, click the cell where you want the result to appear later. Enter an " = " sign and then enter the name for the first cell that you want to multiply. The designations are always made up of the letter of the column and the number of the row, for example " A2 ". Alternatively, you can click on the corresponding cell. Now enter a " * " sign and then the name of the next cell one to be multiplied. Continue until you have inserted all the relevant cells into the formula. If you want to include a constant in the multiplication, you can enter a number instead of a cell name. The formula looks like this, for example: " = A2 * A3 * A5 * 10 ".

2nd step

image
Tap [Enter] to confirm. The result is now displayed in the cell and automatically recalculated by Excel if you change the values ​​in the specified cell references. If you want to change the formula, double click on the cell with the result.

...