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.
- 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.
- 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.