PRODUCT(number1 [,number2] [..])

Returns the product of all the numbers in a list or cell range.

number1The first number.
number2(Optional) The second number.

Remarks

* You can include logical arguments such as true or false. True =1, False=0.
* If an argument is an array or reference, only numbers in the array or reference are counted.
* If an argument is an array or reference, any empty cells, text, or error values are ignored.
* If any of the arguments are text, then #VALUE! is returned.
* You can have a maximum of 30 arguments.
* For the Microsoft documentation refer to support.office.com

 A
1=PRODUCT(5,2) = 10
2=PRODUCT(3,3) = 9
3=PRODUCT(3,3,2) = 18
4=PRODUCT(-3,-3,-2) = -18
5=PRODUCT(3,3,20) = 180
6=PRODUCT(3,{2,2}) = 12
7=PRODUCT(3,{2,2,"some text"}) = 12
8=PRODUCT(TRUE,3) = 3
9=PRODUCT(FALSE,3) = 0
10=PRODUCT(2,2,10/0) = #DIV/0!
11=PRODUCT(2,2,NA()) = #N/A
12=PRODUCT(2,"some text") = #VALUE!

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top