The PRODUCT function is a Math & Trig formula that returns the product of all numbers entered as its arguments. In this guide, we’re going to show you how to use PRODUCT function and also go over some tips and error handling methods.

Supported versions

  • All Excel versions

PRODUCT Function Syntax




The first number or numbers you want to multiply. You can enter a static number like 4, a cell reference like B6, or a cell range like B2:B8.


Optional. The second number or numbers you want to multiply - up to 255 numbers.


Static values

formula multiplies all numbers in the arguments and returns the product.

Individual cells

formula multiplies each value in referred cells.


formula multiples the values in each cell from the reference range. Any valid range can be used with the PRODUCT function.

Download Workbook


  • The PRODUCT function ignores string values. However, please keep in mind that Excel uses date or time values as numbers, not strings.



If the column is too narrow for the result to be displayed, you will see hashtags. The solution is increasing the width of the column.


If there is an error in a reference cell or range, the PRODUCT function returns the same error.