Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does =GAMMAINV(0,5;389;1) return #NUM! ?
why does =GAMMAINV(0,5;389;1) return #NUM! ? This function is supposed to
return num only when parametres are less than or equal 0. Excel solves it numerically, but in case it doesn't find a numeric solution, Excel is supposed to return #N/A error value. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does =GAMMAINV(0,5;389;1) return #NUM! ?
zimmerp,
alpha is too high - probably just not well documented... HTH, Bernie MS Excel MVP "zimmerp" wrote in message ... why does =GAMMAINV(0,5;389;1) return #NUM! ? This function is supposed to return num only when parametres are less than or equal 0. Excel solves it numerically, but in case it doesn't find a numeric solution, Excel is supposed to return #N/A error value. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does =GAMMAINV(0,5;389;1) return #NUM! ?
zimmerp wrote: why does =GAMMAINV(0,5;389;1) return #NUM! ? This function is supposed to return num only when parametres are less than or equal 0. Excel solves it numerically, but in case it doesn't find a numeric solution, Excel is supposed to return #N/A error value. Excel can evaluate GAMMADIST(x,389,1) for 0<= x <= 6E+153. Outside of that range it returns #NUM! So my guess is that during its repeated attempts to solve the equation GAMMADIST(x,389,1) = 0.5, it comes up with an estimate outside this region. A similar example is =GAMMADIST(1E-290,4.4,1E-190,FALSE) where it returns #DIV/0! Again the most plausible explanation is that EXCEL has problems with intermediate calculations. However, only someone with access to the code in Excel could really tell you what the problem is. Ian Smith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
Huge problem with "if" formula's | Excel Discussion (Misc queries) | |||
Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions |