September 28, 2021

# 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: Syntax:  =GAMMALN.PRECISE(A2)

Result: 10.6046029 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: READ:  How to use PERMUTATIONA Function in Excel #### Excel

View all posts by Excel →