Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Maths and Trigonometry > MULTINOMIAL
 

MULTINOMIAL(number1, number2 [,number3] [, …])

 
 Returns multinomial of a set of numbers in a list or cell range.

 number1The first number.
 number2The second number.
 number3The third optional number.

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• The multinomial is basically the ratio of the factorial of a sum of values to the product of the factorials.
     
  		• If any argument is less than one, then #NUM! is returned.
     
  		• If any argument is not numeric, then #VALUE! is returned.
     
  		• You can have a maximum of 29 arguments.

     EXAMPLES
     
     A
    1=MULTINOMIAL(2,3,4) = 1260
    2=MULTINOMIAL(1,2,3) = 60
    3=MULTINOMIAL(3,2,1) = 60
    4=MULTINOMIAL(3,-2,1) = #NUM!
    5=MULTINOMIAL(3,2,"some text") = #VALUE!
    		 
     Functions - M | Index - M | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top