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.
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:
Based on the Excel spreadsheet above, the following GAMMALN.PRECISE examples would return:
- 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))