PRODUCT

The PRODUCT function in Google Sheets returns the result of multiplying a series of numbers together. This function is useful when you need to calculate the product of multiple factors. Learn how to use this function effectively with our comprehensive guide.

Parameters

• factor1: The first factor or range of factors to multiply.
• factor2, ...: [Optional] Additional factors or ranges to multiply.

Step-by-Step Tutorial

1. Using PRODUCT with individual numbers:
   • Example: =PRODUCT(3, 10, 5)
   • Result: 150

Working with a Single Value, a List, and a Range

PRODUCT accepts numbers one at a time, as a comma-separated list, or as a range — mix and match freely.

• Single value: =PRODUCT(A1) — just returns the value in A1.
• List of values: =PRODUCT(A1, A2, A3) — if A1, A2, A3 are 3, 10, 5, this returns 150.
• Range: =PRODUCT(A1:A10) — multiplies every cell in the range together.
• Mixed: =PRODUCT(A1, A3:A6, 10) — you can combine single cells, ranges, and literal numbers in one call.

Use Cases and Scenarios

1. Inventory Management: Calculate the total quantity by multiplying unit price with quantity for each item.
2. Financial Projections: Compute the total projected revenue by multiplying sales forecasts with average selling price.
3. Loan Repayment: Determine the total interest paid over the life of a loan by multiplying the principal amount with the interest rate.

Related Functions

• SUM: Add up a range of numbers.
• MAX: Find the largest value in a set.
• MIN: Find the smallest value in a set.

Related Articles

• Top 4 Basic Arithmetic Functions Every Google Sheets User Should Know