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:
