Dear all,
I don't understand the reason why if I type the fomular: = GAMMADIST(4,0.11,35.5,TRUE), the return result is wrong "#NUM!".
(if I replace 4 by 4.1 or 4.2, I have the same results), on the other, if it is not these figures, the results are true)
It would highly appreciate it if you help me, please!
Many thanks
Best regards,
Thanh
It works for me returning
0.8211740
Can you post your workbook with not wirking example?
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Dear RobertMika,
Tks for getting your feedback quickly, can you help me to plot Gamma distribution and cumulative function on workbook1 (attached file) ?
Best regards,
Thanh
Is working for me.
Is Your Automatic Calculation switch on?
Formulas-Calculation Options-Automatic?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks