The Excel GAMMALN Function

Home » Excel-Built-In-Functions » Excel-Statistical-Functions » Excel-Gammaln-Function

Search this site:

Custom Search

Related Function:

GAMMADIST

GAMMALN and GAMMALN.PRECISE Functions

In Excel 2010, the Gammaln function has been replaced by the Gammaln.Precise function, which has improved accuracy.

Although it has been replaced, the Gammaln function is still available in Excel 2010 (stored in the list of compatibility functions), to allow compatibility with earlier versions of Excel.

Basic Description

The Excel Gammaln function returns the natural logarithm of the Gamma Distribution.

The syntax of the function is :

GAMMALN( x )

where x is the positive value at which you want to evaluate the function.

Natural Logarithm of the Gamma Distribution

Gammaln Function Example

The chart on the right shows the natural logarithm of the Gamma Distribution.

If you want to calculate the value of this function at x = 4.5, this can be done by the Excel Gammaln function, as follows:

=GAMMALN( 4.5 )

This gives the result 2.453736571.

Further examples of the Excel Gammaln function can be found on the Microsoft Office website.

Gammaln Function Errors

If you get an error from the Excel Gammaln function this is likely to be one of the following :

Common Errors

#NUM!	-	Occurs if the supplied value of x is ≤ 0
#VALUE!	-	Occurs if the supplied value of x is not recognised as a numeric value

Return to the Excel Statistical Functions Page

Return to the List of All Built-In Excel Functions

Disclaimer

Privacy Policy