"Andy1973" wrote...
Can anyone tell me how to go about getting the multinomial function
(Office 2000 Pro)? Help tells me to run the Setup program but I
can't see how to do this.

It may seem convenient to use the MULTINOMIAL function in the ATP, but it
chokes on moderately large values. For instance, MULTINOMIAL(50,50,50,50)
returns #NUM!. An alternative that uses only built-in functions and accepts
a much broader set of numbers as arguments is

=EXP(GAMMALN(SUM(RangeOrArray)+1)-SUMPRODUCT(GAMMALN(RangeOrArray+1)))

E.g.,

=EXP(GAMMALN(SUM({50,50,50,50})+1)-SUMPRODUCT(GAMMALN({50,50,50,50}+1)))

returns 9.217E+116.