Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 Excel > Functions > Maths and Trigonometry > PRODUCT
 

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

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

 number1The first number.
 number2The second number.
 number3(Optional) The third optional 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.

     EXAMPLES
     
     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!
    		 
     Functions - P | Index - P | Office Online 2003 | Office Online 2007 

     Copyright © 2010 Better Solutions Limited. All Rights Reserved.Top