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

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

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

Remarks

* 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.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.com

 A
1=MULTINOMIAL(2,3,4) = £1,260.00
2=MULTINOMIAL(1,2,3) = £60.00
3=MULTINOMIAL(3,2,1) = 60
4=MULTINOMIAL("3","2",1) = 60
5=MULTINOMIAL(3,-2,1) = #NUM!
6=MULTINOMIAL(3,2,"some text") = #VALUE!


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