View Single Post
  #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.