GAMMALN.PRECISE Function in Excel: Natural Log of Gamma (2010+ Version)

GAMMALN.PRECISE Function in Excel: Natural Log of Gamma (2010+ Version) 1
⏱ 1 min readUpdated 5 October 2026

StatisticsLevel: ExpertAvailable in: Excel 2010+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. GAMMALN.PRECISE in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions

GAMMALN.PRECISE is the 2010 version of GAMMALN with the same result and improved accuracy.

Advertisement

Syntax

=GAMMALN.PRECISE(x)
Argument What it means
x Positive number

Examples

Example 1

=ROUND(GAMMALN.PRECISE(A2),4)

Result: 3.1781. See the worked example table below for more cases.

GAMMALN.PRECISE in practice

Where you will use it

  • Same uses as GAMMALN
  • New models
  • Statistics

Worked example

xFormulaResult
5=ROUND(GAMMALN.PRECISE(A2),4)3.1781
100=ROUND(GAMMALN.PRECISE(A3),4)359.1342
0.5=ROUND(GAMMALN.PRECISE(A4),4)0.5724

Results calculated in Excel.

Mistakes people make

MistakeWhat to do instead
x of 0 or less#NUM!
Mixing with GAMMALNUse one consistently

GAMMALN

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZMONTH Function in Excel: Month Number From a DateExcel Functions A–ZIMCOSH Function in Excel: Hyperbolic Cosine of a Complex NumberExcel Functions A–ZNUMBERVALUE Function in Excel: Convert Text Numbers With Any Separators
Advertisement
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong