Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zimmerp
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Intervals of 1 Numeric value in a Row and Return Count down Column Sam via OfficeKB.com Excel Worksheet Functions 8 October 4th 05 04:37 PM
Huge problem with "if" formula's [email protected] Excel Discussion (Misc queries) 16 July 20th 05 07:20 PM
Excel - return a picture or range rows as the result of a formula juststarting Excel Worksheet Functions 1 July 4th 05 12:59 AM
How do create a formula to evalute a # to return 1 of 4 conditions Larry Excel Worksheet Functions 4 May 29th 05 12:58 AM
if the value of a cell in a range is not blank, then return the v. kvail Excel Worksheet Functions 2 April 8th 05 10:07 PM


All times are GMT +1. The time now is 07:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"