Hey
Attached in my excel sheet you see dominant #NA.
The array formula works fine (I think)
In the yellow area I have tested several solutions, but none of them works
I hope you can and will help :)
Hello
I have the next values for a PERT distribution in Excel 2010:
optimistic € 1,20 A1
most-likely € 1,35 A2
Pessimistic € 1,90 A3
I want to calculate in excel the percentile for € 1,50 of this PERT distribution.