help with gammainv function

[cherylv]

I'm having some trouble with the GAMMAINV function.

My parameters are alpha=0.1 and beta=242, but Excel will not return values for probabilities between 0.81 and 0.861 inclusive (tested at 0.001 intervals).

Can anyone explain why this might be??

If alpha is changed to 0.2 (for example) then there are no problems.

Thanks in advance!

(Apologies, this is also in general section...didn't mean to post it there originally)

[NBVC]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.