Tuesday 27 August 2013

How to use GAMMA function _xlfn.GAMMA?

How to use GAMMA function _xlfn.GAMMA?

Microsoft website has an introduction on GAMMA function.
I could download it and have a look, the formula is shown as
=_xlfn.GAMMA(2.5).
However, when I create a new excel file, I can't use it, neither by write
formula as =_xlfn.GAMMA(2.5)" or "=GAMMA(2.5).
Did I missed something? Is there some library I shall register, like using
Solver function?
I'm using Excel 2007. The msdn page says "GAMMA" function applies to Excel
2003, so I guess the problem is not the version, but some usage trick.

No comments:

Post a Comment