Hello Olivier and Steve,
I could sense an error on the help pages for BETA.INV and BETAINV function.
The definition of Number is wrong. It states Number to be between Start and
End but actually it is the probability which is associated with BETA
function for other given arguments and the output will be that Number.
Compare it with MS excel equivalent
https://support.microsoft.com/en-us/office/beta-inv-function-e84cb8aa-8df0-4cf6-9892-83a341d252eb
.
Actually out function works the same way but the description of this Number
is wrong.
One eg to prove the point is : =BETA.INV(0.5,3,4,3,4) gives 3.42140719069071
But =BETA.INV(3.5,3,4,3,4) gives Err:502 which infact qualifies the
definition.
Ronnie Gandhi
Undergraduate at Computer Science and Engineering
Indian Institute of Technology, Roorkee
+91-07874243430