PRODUCT
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.
PRODUCT
(
[Units sold]
,
[Unit price]
)
Result
Sales
12000
25861
5868
10640
19320
34694
10836
31440
14748
18270
13068
30576
Last updated