View Single Post
  #1   Report Post  
anb001
 
Posts: n/a
Default Re 'BINOMDIST' function


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