- You can easily multiply in Google Sheets using formulas – once you know how they function.
- You can use a formula to perform simple multiplication functions using either numbers you specify, or cell data. You can also take the formula and easily apply it to other cells.
- Here’s how to use the formula feature in Google Sheets to multiply.
- Visit Business Insider’s homepage for more stories.
Formulas are one of those spreadsheet features that seem complicated, but once you get the hang of them and know their structure, are actually quite simple.
Here’s a quick breakdown of how to use the multiplication formula in Google Sheets using either numbers you type in, or cell data, as well as how to take that formula and apply it to other cells.
Check out the products mentioned in this article:
How to multiply in Google Sheets using simple multiplication
2. Select the cell where you want to apply the multiplication feature.
3. Type “=”, which will prompt the formula feature to activate within the cell.
4. Enter your desired multiplication factor as “X*Y” – for example, to multiply 8 by 9, you’d type “8*9.”
How to multiply in Google Sheets using cell data
If you want to set up a formula using numbers that are already entered in other cells, here’s how to get it done:
1. Open your spreadsheet.
2. Select the cell where you want to enter the formula.
3. Type “=” in the cell.
4. Select the first cell that you want to use for your multiplication problem (alternatively, you could instead type the cell name, like “A2”).
5. Type “*” into the box to signify that you’re multiplying.
6. Select the second cell you want to use for your multiplication problem (or enter the cell name manually).
7. Hit “Enter” or “Return” to see the answer to your query.
How to multiply in Google Sheets by copying the formula into additional cells
Using the multiplication formula can be useful, but doing it bit-by-bit for an entire column can get tedious. Here’s a quick and easy workaround for that problem.
Even after you’ve multiplied using a formula, the cell you used to multiply still keeps the formula around. So, you can do this:
1. Select the cell with the formula you want to copy by holding Command + C on your Mac, or Ctrl + C on your PC keyboard.
2. Select the cells you want to apply the formula to, and then press Command + V on your Mac or Ctrl + V on your PC keyboard to paste the formula in.
3. The cells will automatically populate with the formula, adapting it for each row or column.
- embed type
- embed type