Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Microsoft website has an introduction on GAMMA function.

I could download it and have a look, it's a ".xlsx" file and the formula is shown as =_xlfn.GAMMA(2.5).

enter image description here

However, when I create a new excel ".xlsx" file, I can't use it, neither by write formula as =_xlfn.GAMMA(2.5)" or "=GAMMA(2.5). enter image description here

Did I missed something? Is there some library I shall register, like using Solver function?


Clarification

@dave-rook is right.

I'm using Excel 2007. The msdn page says "GAMMA" function applies to Excel 2013, so the problem is the version.

share|improve this question
    
What version of Excel are you using? –  Dave Rook Aug 27 '13 at 15:16
    
youre right the function isnt included with the workbook. it does work on the embed spreadsheet on the web, but its not anywhere to find within the downloaded file itself. –  me how Aug 27 '13 at 15:59
    
is there some library can do that? i know that excel can have plugin's.. –  athos Aug 27 '13 at 16:16

2 Answers 2

up vote 0 down vote accepted

In excel 2003 and up you can use

=EXP(GAMMALN(value))

For all positive values

share|improve this answer

If GAMMALN is not available under your language settings, you may need to be using the following formula:

=GAMMA.LN(EXP(value))
share|improve this answer
    
This is better as a comment perhaps –  Dave M Feb 8 at 18:01

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.