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

PRODUCT(number1,[number2],…)


Arguments

number1

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.

[number2]

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



Examples

Static values

=PRODUCT(78,84,78,109,85,100)
formula multiplies all numbers in the arguments and returns the product.

Individual cells

=PRODUCT(F3,G3,H3)
formula multiplies each value in referred cells.

Range

=PRODUCT(F3:H3)
formula multiples the values in each cell from the reference range. Any valid range can be used with the PRODUCT function.

Download Workbook


Tips

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

Issues

#####

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.

Error

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