Zoho Sheet PRODUCT: Multiply Ranges, Dimensions and Growth Factors

• Introduced: Original introduction release and date are not established by the checked sources.
• Availability: Currently documented in Zoho Sheet’s rolling web-service help; no retirement endpoint is established.
• Scope: English web-service documentation. Exact mobile and offline-client parity is unverified.
• Checked: October 14, 2026, against the official PRODUCT reference. Documentation and independent typed/exact calculations; no native Zoho Sheet test.

=PRODUCT(number1; number2; ...)

Zoho’s printed signature lists successive numbers. Its remarks explicitly say that a single numeric input returns that number, so =PRODUCT(7) returns 7. A referenced range can provide the numeric factors, as in the official range example.

The page does not fully define zero-argument, empty-range, text, Boolean or error-cell handling. This guide deliberately supplies actual numbers, and does not borrow another program’s rules for skipping cells or converting text.

Create BoxVolumes with Box, Length, Width, Height, PRODUCT and Multiplication in A1:F1. Enter numeric measurements in the same length unit:

In E2 enter =PRODUCT(B2:D2) and in F2 enter =B2*C2*D2. Fill E2:F2 through row 5. The results are in cubic units because three length measurements are multiplied.

The fourth row is a numerical zero-factor control, not a usable physical box. A zero dimension makes the product zero. PRODUCT does not decide whether the dimensions describe a valid item, and it does not convert mixed units automatically.

In H2 enter =PRODUCT(B2:C2;D2); expect 24. Splitting the factors between a range and one cell preserves the calculation when each factor is included once.

Create ProductControls with Case and Formula result in A1:B1. Enter these formulas in B2:B7:

B2 and B4 reproduce the directly specified inputs in Zoho’s examples. Its separate D2:E2 example gives 6.8, but the article text does not expose both embedded source cells; this tutorial does not invent them.

One negative factor changes the sign; two negatives give a positive product. A supplied numeric zero makes a finite all-numeric product zero. Neither statement defines how an error, missing cell or nonnumeric input would be handled.

Create OverlapCheck with numeric 2,3,5 in A2:A4. Put =PRODUCT(A2:A4) in C2; expect 30. In C3 enter =PRODUCT(A2:A3;A3:A4); expect 90. In C4 enter =C3/C2; expect 3, the duplicated factor from A3.

The repeated cell is included in both supplied ranges. In C5 enter =PRODUCT(A2:A3;A4); expect 30, because the two arguments now cover each input once. A plausible product does not prove the selected ranges are disjoint.

Create GrowthFactors with Period, Change, Factor and Closing balance in A1:D1. Enter 1,2,3 in A2:A4 and percentage changes 10%,−10%,5% in B2:B4. Put Starting value in F1 and numeric 1000 in F2.

Enter =1+B2 in C2 and fill through C4. Expect 1.1,0.9,1.05. In D2 enter =$F$2*C2; expect 1100. In D3 enter =D2*C3 and fill through D4; expect 990,1039.5.

The factors multiply because each change applies to the current amount. Adding the three percentages produces a different model, illustrated by H3. This is a mathematical compounding example without contributions or withdrawals, not a forecast of any investment’s outcome.

Use the stored percentage values in B rather than entering 10 for 10%. Multiplying the rates themselves would also be wrong: the factors are 1+rate, not the rates alone.

Create DiscountFactors with numeric price 200 in B2, and retained-price factors 0.8 and 0.9 in B3:B4. Enter =PRODUCT(B2:B4) in D2; expect 144. In D3 enter =1-PRODUCT(B3:B4); expect 0.28, or 28% off the original price.

A 20% reduction followed by 10% off the reduced price leaves 72% of the original. In D4 enter =B2*(1-0.2-0.1); expect 140. That subtracts both percentages from the original base and is not the same pricing rule. These formulas do not specify a currency-rounding policy for other inputs.

Keep source ranges free of output formulas so they cannot refer back to themselves. Check numeric storage, measurement units, repeated factors and percentage entry before interpreting a surprising product. Extremely large or small products may also encounter finite-precision limits; none are established by the short function reference.

SUM adds values rather than multiplying them. POWER is useful for a repeated identical factor, while GEOMEAN addresses a geometric average under its own domain rules. No cross-program text/coercion parity is implied by the shared PRODUCT name.