Explanation of the PRODUCT function
The PRODUCT function will multiply the numbers that you provide as inputs. The image below shows the arguments that the function is asking for:
- At least 1 numeric input (required)
- Up to a total of 255 numeric inputs (optional)
Note (values ignored): logical values (TRUE or FALSE), text values, and empty cells are ignored by the function.
The safest option is to pass the function only a range of numbers, however you also have the option to use the MULTIPLICATION mathematical operator which in Microsoft Excel is the asterisk * symbol on your keyboard. An example formula would be =2*5 which would give you 10.
Back to the PRODUCT function, the syntax is shown below…
There are a few different ways you can input values:
- Single Cell (would just return the same number)
- Multiple cells selected individually
- One range of cells
- Multiple ranges of cells
- Number values typed directly into the function
- Named ranges
- A combination of the above (separated by commas within the function)
In the image below I have manually named range B6:B7 as ‘product_range’. The last formula is calculating the PRODUCT of ‘product_range’ which is the same as multiplying all of the numbers within B6:B7 (in this case 4*5).
Go back to Excel Tutorials.