The PRODUCT function returns the product of all values in the arguments.
Syntax
PRODUCT(value1, ...valueN?) - > number
Arguments
Arguments
Datatype
Description
value1
Number/Node reference
The first node or number to be multiplied. This is a required argument.
...valueN?
Number/Node reference
The additional nodes or numbers to be multiplied. These are optional arguments.
Example
Consider the below example where we have data for Units sold and price. The objective is to calculate Sales value by multiplying Units sold with Unit price.
Periods
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Units sold
2000
2351
978
1520
2415
3154
1548
3144
2458
3654
1452
2548
Unit price
6
11
6
7
8
11
7
10
6
5
9
12
To achieve this, the following formula should be written in the [Sales] node.
