How to use GAMMALN.PRECISE Function in Excel

The Excel Gammaln.Precise function returns the natural logarithm of the Gamma Function, Γ(n). The function is new in Excel 2010 and so is not available in earlier versions of Excel. However, the Gammaln.Precise function is simply an updated version of the Gammaln function, which  is available in earlier versions of Excel.

Syntax:= GAMMALN.PRECISE(x)

The GAMMALN.PRECISE function syntax has the following arguments:

  • X: Required. The value for which you want to calculate GAMMALN.PRECISE.

Example: Let’s look at some Excel GAMMALN.PRECISE function examples and explore how to use the GAMMALN.PRECISE function as a worksheet function in Microsoft Excel:

GAMMALN.PRECISE Function - How to use GAMMALN.PRECISE Function in Excel

Syntax:  =GAMMALN.PRECISE(A2)

Result: 10.6046029

GAMMALN.PRECISE Function in Excel 1 - How to use GAMMALN.PRECISE Function in Excel

Based on the Excel spreadsheet above, the following GAMMALN.PRECISE examples would return:

Syntax: =GAMMALN.PRECISE(A3)
Result: 9.03318692

Syntax: =GAMMALN.PRECISE(A4)
Result: 54.7847294

Syntax: =GAMMALN.PRECISE(A5)
Result: #NUM!

Syntax: =GAMMALN.PRECISE(A6)
Result: #NUM!

Syntax: =GAMMALN.PRECISE(A7)
Result: #VALUE!

Syntax: =GAMMALN.PRECISE(A8)
Result: 1.791759469

Syntax: =GAMMALN.PRECISE(A9)
Result: 0.28468287

Syntax: =GAMMALN.PRECISE(A10)
Result: 4.787491743

Syntax: =GAMMALN.PRECISE(A11)
Result: 3.639636069

Note:

  • If x is nonnumeric, GAMMALN.PRECISE returns the #VALUE! error value.
  • If x ≤ 0, GAMMALN.PRECISE returns the #NUM! error value.
  • The number e raised to the GAMMALN.PRECISE(i) power, where i is an integer, returns the same result as (i – 1)!.
  • GAMMALN.PRECISE is calculated as follows:GAMMALN.PRECISE = LN(Γ(x))

    where:
    GAMMALN.PRECISE Function in Excel - How to use GAMMALN.PRECISE Function in Excel

 

 

 

 

Add a Comment

Your email address will not be published. Required fields are marked *