View Single Post
  #5   Report Post  
Dana DeLouis
 
Posts: n/a
Default

This is one way to get Gamma(A1):

=EXP(GAMMALN(A1))

It's been noted before that it's only good to about 9 or 10 digits of
accuracy.
--
Dana DeLouis
Win XP & Office 2003


"Bob Phillips" wrote in message
...
There is no intrinsic GAMMA function in Excel, although there are
GAMMADIST,
GAMMAINV, GAMMALN. I suggest that you look these up in help to see what
they
do.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cardiff Maths Student" <Cardiff Maths
wrote in message
...
Hi!
I'm trying to use a formula that contains the Gamma function in Excel
but this does not seem to be under the list of functions. If I type its
definition:
Gamma(n)=(n-1)! it gives an error message when n-1 is
not
an integer.
Has anyone got any ideas how I can get past this?
Thanks