Google Sheets: How to Use the Multiply Formula for Easy Calculations

Google Sheets is a powerful tool that allows you to perform a variety of calculations, including multiplication. If you need to multiply numbers, cells, or ranges in Google Sheets, it’s as simple as using the multiply formula. In just a few clicks, you can have your multiplication results ready to go.

Step by Step Tutorial: Multiply Formula in Google Sheets

Before we dive into the steps, it’s important to understand what we’re trying to achieve. The multiply formula in Google Sheets multiplies numbers, cells, or ranges together to give you a product. Follow these steps to get it done:

Step 1: Open Your Google Sheets Document

Open the Google Sheets document where you want to perform the multiplication.

When you open your Google Sheets document, make sure you’re on the right sheet where you want the multiplication to take place.

Step 2: Click on the Cell Where You Want the Result

Select the cell where you want the multiplication result to appear.

It’s essential to click on the cell to make it active so that the formula you type will be applied to that cell.

Step 3: Type the Multiply Formula

Type the formula =product(number1, number2,...) into the selected cell.

The product function is what tells Google Sheets you want to multiply. You can multiply two numbers directly or use cell references (like A1, B2) to multiply values in those cells.

Step 4: Press Enter

After typing the formula, press Enter to get the multiplication result.

Once you press Enter, the cell will display the product of the numbers or cell values you’ve multiplied.

After completing the action, the cell where you typed the formula will show the result of the multiplication. You can use this same method to multiply as many numbers or cells as needed.

Tips: Using the Multiply Formula in Google Sheets

  • You can multiply more than two values by continuing to add numbers or cell references within the parentheses.
  • If you need to multiply an entire range of cells by a single number, use the ARRAYFORMULA function in combination with product.
  • You can also use the asterisk () symbol to multiply values, such as `=A1A2`.
  • Remember that cell references are case-insensitive, so it doesn’t matter if you type them in uppercase or lowercase.
  • If you’re multiplying mixed data types (numbers and cells), ensure that the cells you’re referencing do not contain text, as this will result in an error.

Frequently Asked Questions

Can I multiply entire columns in Google Sheets?

Yes, you can multiply entire columns by using the ARRAYFORMULA function combined with the multiplication operator (*).

What if I get an error message when using the multiply formula?

Ensure that all the cells you’re referencing contain numbers and not text. Also, check that your formula syntax is correct.

Can I use the multiply formula with decimal numbers?

Absolutely! Google Sheets can handle decimal numbers in the multiply formula just like whole numbers.

How do I multiply a range of cells by a constant number?

Use the ARRAYFORMULA function with the multiplication operator (*) and the constant number you want to multiply the range by.

Can I use the multiply formula to multiply percentages?

Yes, you can. Make sure the percentages are formatted correctly in Google Sheets, and they’ll multiply just fine.


  1. Open your Google Sheets document.
  2. Click on the cell where you want the result.
  3. Type the multiply formula.
  4. Press Enter.


Mastering the multiply formula in Google Sheets can save you a ton of time, especially when dealing with large datasets or complex calculations. Whether you’re a student, a business analyst, or just someone who loves crunching numbers, knowing how to use the multiply formula effectively can make your life much easier. So go ahead, give it a try, and watch how quickly you can get results. And remember, practice makes perfect! Keep experimenting with different numbers and scenarios to become a Google Sheets multiplication whiz.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy