Issue understanding PROB function

Hello Steve and Olivier,

I am having an issue understanding PROB. I tried running the function using
details from help and in the same way as MS's counterpart but in Calc it
returns a #VALUE! error. Can you point out the reason for the same since I
am unable to get any legit numerical result till now.
[image: error_prob.png]

Ronnie Gandhi
Undergraduate at Computer Science and Engineering
Indian Institute of Technology, Roorkee

Hi Ronnie,

I haven't done a thorough analysis but have you noticed the condition in the ODF description of this function that says "The sum of the probabilities in Probability shall equal 1". Clearly your worked example violates that guidance, which may be your problem.