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)
Individual cells
=PRODUCT(F3,G3,H3)
Range
=PRODUCT(F3:H3)
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.