ExcelExcel 2010+
GAMMALN.PRECISE function in Excel
Returns the natural logarithm of the gamma function, Γ(x)
=GAMMALN.PRECISE(x)GAMMALN.PRECISE syntax and parameters
One argument, one required.
- xnumberRequired
The value for which you want to calculate GAMMALN.PRECISE.
GAMMALN.PRECISE examples
Formulas you'll actually reuse.
ln Γ(x) for x = 6:
=GAMMALN.PRECISE(B2)Result
4.7875A huge binomial coefficient without overflow — log space, then EXP:
=EXP(GAMMALN.PRECISE(B2 + 1) - GAMMALN.PRECISE(C2 + 1) - GAMMALN.PRECISE(B2 - C2 + 1))Result
13983816
GAMMALN.PRECISE in Google Sheets
Same name — your formula ports as-is.
Try GAMMALN.PRECISE in the playground
Edit the example — nothing to install.
Preloaded with the GAMMALN.PRECISE formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Excel gets this done.
- AVERAGEIFReturns the average (arithmetic mean) of all the cells in a range that meet a given criteriaStatisticalGoogle Sheets
- COUNTBLANKCounts the number of blank cells within a rangeStatisticalGoogle Sheets
- COUNTIFCounts the number of cells within a range that meet the given criteriaStatisticalGoogle Sheets
- COUNTIFSCounts the number of cells within a range that meet multiple criteriaStatisticalGoogle Sheets
- FORECAST.LINEARReturns a future value based on existing valuesStatisticalGoogle Sheets
- GAMMALNReturns the natural logarithm of the gamma function, Γ(x)StatisticalGoogle Sheets