Formulas > =MULTIPLY()

How To Use MULTIPLY() Function in Google Sheets


Returns the product of two numbers. Equivalent to the `*` operator.

Common questions about the MULTIPLY formula:

1. What is the syntax of the MULTIPLY formula?
2. How do I apply the MULTIPLY formula?
3. How do I access the MULTIPLY formula in Google Sheets?

How can the MULTIPLY formula be used appropriately?

The MULTIPLY formula can be used to calculate the product of two numbers or cells, such as the estimated cost of an item or multiple items multiplied together. It can also be used to calculate a percentage or fraction of the total.

How can the MULTIPLY formula be commonly mistyped?

The MULTIPLY formula uses a multiplication operator (the asterisk * symbol) to indicate multiplication, and this often needs to be included or it will not be accepted as a valid formula.

What are some common ways the MULTIPLY formula is used inappropriately?

The MULTIPLY formula should not be used to add or subtract numbers. It should also not be used to calculate powers or exponents, or to perform mathematical operations on a single cell.

What are some common pitfalls when using the MULTIPLY formula?

It is important to ensure that the order of the numbers or cell references in the formula are correct, as the order will determine the answer. Care should also be taken when using multiplication to perform percentages or fractions, as the MULTIPLY formula will treat these as numbers and not percentages or fractions.

What are common mistakes when using the MULTIPLY Formula?

Common mistakes when using the MULTIPLY Formula involve mistyping the multiplication operator, putting the numbers/cell references in the wrong order, and failing to include the multiplication operator.

What are common misconceptions people might have with the MULTIPLY Formula?

Some people mistakenly believe that the MULTIPLY formula can only be used to multiply two numbers or cell references, when in fact it can also be used to calculate fractions or percentages of the total. Additionally, some people believe that this formula can be used to add or subtract numbers, or to calculate powers or exponents of a number, when in fact this is not the case."

How To Actually Use MULTIPLY() in Sheets

MULTIPLY(factor1, factor2)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the MULTIPLY() formula:

Add, Subtract, Multiply, & Divide

Learn basic operator functions in a Google spreadsheet. If viewing in full screen mode, select the HD quality option. More videos can be found on

Generate a MULTIPLY() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.