In Excel 2003, I get the following

=BINOMDIST(564,1757,0.33333,TRUE)

returns:
0.142006496

I think this was one of the fixes they did to the statistical functions.
See Microsoft's kb article number 827459

(Microsoft's support site is down right now...It is requiring a Passport to
get to their site, and locks up Internet explorer :0 )

--
Dana DeLouis
Win XP & Office 2003


"anb001" wrote in message
...

When creating the below function, I get a [#NUM!] error:

=BINOMDIST(564;1757;0.33333;TRUE)

But when I change the 'trials' number (1757), to something closer to
'1000', e.g. '1010', then it returns a value, as it should.

How can this be (I'm using Excel XP)?



--
anb001
------------------------------------------------------------------------
anb001's Profile:
http://www.excelforum.com/member.php...fo&userid=2809
View this thread: http://www.excelforum.com/showthread...hreadid=278262