MULTIPLY in Google Sheets: Two Factors, Prices and Percentages

=MULTIPLY(factor1, factor2)

Both factors are required. A single numeric cell reference supplies a scalar value. The Google MULTIPLY reference states the two-scalar restriction; there are no optional arguments or defaults.

Use PRODUCT when you want to multiply a series or range into one result. Use a row-by-row formula when each record needs its own total. Do not assume that passing two ranges into MULTIPLY performs a documented elementwise calculation.

Enter this table in A1:C4:

Put Line total in D1. In D2 enter and fill down to D4:

=MULTIPLY(B2,C2)

Expected totals: 100, 36, 0. Each row multiplies one price by its own quantity. Enter =SUM(D2:D4) in D6; expected combined amount: 136.

For an independent arithmetic comparison, =B2*C2 has the documented expected result 100. Zero quantity gives a zero total; a missing quantity is a separate data-quality issue and should not be silently assumed to mean zero.

To multiply 2, 3 and 4:

=MULTIPLY(MULTIPLY(2,3),4)
=PRODUCT(2,3,4)

Both have expected result 24. The first performs two valid two-factor operations; the second uses Google’s separately documented PRODUCT function, which accepts multiple values and ranges.

=MULTIPLY(2,3,4) is outside the documented argument contract. Likewise, =MULTIPLY(B2:B4,C2:C4) is not the range form promised by this help page. Do not present an array workaround as if it were ordinary scalar syntax.

PRODUCT across all prices and all quantities would multiply every value together. It would not add the row totals. For a total of paired products, review SUMPRODUCT rather than confusing it with PRODUCT.

Use the notebook’s original total of 100. Put 15% in F2 and 8% in F3. The discounted subtotal is 100×(1−0.15) = 85; applying an 8% surcharge to that subtotal gives:

=MULTIPLY(MULTIPLY(D2,1-$F$2),1+$F$3)

Expected result: 91.8. The shared percentage cells are locked so copying the formula to another line preserves the rates.

For an 8% addition without the discount:

=MULTIPLY(D2,1+$F$3)

Expected result: 108. Multiplying the subtotal by 8% alone would compute only the added amount, 8, not the total including it.

The example demonstrates arithmetic, not a tax or commercial rule. Actual invoices may apply discounts, charges and rounding at different stages. State the required order before translating it into a formula.

=MULTIPLY(-4,-3) has expected result 12, while =MULTIPLY(8,-2) has expected result −16. Two negative factors give a positive product. A reversal flag combined with an already-negative value can therefore undo a sign convention unexpectedly.

Check units: price per item × item count gives an amount. Price per kilogram × grams requires a unit conversion first. The function cannot infer units from headings.

Decimal arithmetic can produce small floating-point residuals. Showing two decimals does not necessarily round the stored result. If a downstream calculation needs a rounded amount, use a deliberate ROUND formula and the rounding stage specified for the workflow.

• Supply exactly two scalar factors; use PRODUCT for a genuine range product.
• Check imported numbers, decimal separators and accidental text labels.
• Verify that price and quantity references remain paired after sorting or filling.
• Confirm percentages are stored as 0.15 and 0.08, not 15 and 8, in the adjustment example.
• Check whether a zero result comes from an intended zero factor or from missing data elsewhere in the model.

Google does not enumerate a complete native error-code, text-coercion or blank-reference matrix on this function page. No such outcomes are inferred here from Excel or another application.

MULTIPLY is documented in the rolling Google Sheets service. No original introduction date, introduction version or last functioning numbered release was established. When exporting a workbook, verify the destination’s named function support or its documented multiplication operator; scalar arithmetic correspondence is not a guarantee of imported array behavior.

NOT_TESTED_IN_GOOGLE_SHEETS. Google’s individual MULTIPLY and PRODUCT references were inspected on October 17, 2026. All results were independently calculated with decimal arithmetic. No native Sheets execution or screenshot was performed.

Related published guides: PRODUCT, SUMPRODUCT, SUM and ROUND.