Excel like a finance pro.
← The libraryPractice · 2 questions →
Statistical function
GAMMALN.PRECISE
Returns the natural logarithm of the gamma function with improved precision.
Rarely usedDifficulty 1500 · AdvancedUsage rank #399 of 520
When to use it
GAMMALN with higher precision.
The shape of it
- Syntax
=GAMMALN.PRECISE(x)
Worked examples
Small value
=GAMMALN.PRECISE(5) → 3.17805383
LN(24).
Half
=GAMMALN.PRECISE(0.5) → 0.572364943
LN of the square root of pi.
Ten
=GAMMALN.PRECISE(10) → 12.80182748
LN(362880).
Worth knowing
- Use it in any new formula; the results agree with GAMMALN to many digits.
- Same rules: input must be positive.
- Handy in likelihood calculations.
Where it goes wrong
- #NUM! for non-positive input.
- Not available in Excel 2007.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.