How to Multiply in Excel

How to Multiply in Excel

In the previous parts of this Excel tutorial, you have been working on a spreadsheet that now looks like this:

Bottom of Spreadsheet

To get the weekly cost of each chocolate bar, we need to multiply the Number of bars eaten in one week by the Price. This can then go in the Cost column. The standard way to multiply things is like this:

12 x 10 = 120

The “x” means multiply. In a spreadsheet, however, the letter “x” is not used to multiply things. Spreadsheets use the asterisk symbol instead (the one above the number 8 on your keyboard, in the UK). The previous sum would then look like this:

12 * 10 = 120

Actually, in Excel, you don’t need much more than that to multiply. The only other thing you need is an equals sign before the formula. So to get the answer 120, you’d just enter this into any cell:

= 12 * 10

Instead of entering numbers directly, though, we’ll enter a cell reference instead. To multiply, then, try this:

  • Click into cell D15 on your spreadsheet, just below your Cost heading
  • Now click into the Formula Bar at the top of Excel
  • Type the following formula:

= B15 * C15

  • Hit the enter key on your keyboard, and you should get an answer of 5.95
  • Your spreadsheet will look like this (we’ve formatted the cell as a currency):

The first Cost has been entered

So to multiply in Excel , you do this:

= Cell Reference * Cell Reference

You type the equals sign first ( = ), followed by the first cell. Type an asterisk ( * ), and then the second cell. Hit the enter key, and Excel will multiply the two cells for you:

= B15 * C15

Once you have that first formula in place, you can use AutoFill for the others:

All the Costs have been filled in

After you’re done, you should have the same figures that we have in the Cost column.

In the next part of the tutorial, you’ll complete this Excel spreadsheet by adding a weekly cost and a yearly cost.

Advertisements

Give A message for us

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s