Excel
GAMMALN function in Excel
Returns the natural logarithm of the gamma function, Γ(x)
=GAMMALN(x)GAMMALN syntax and parameters
One argument, one required.
- xnumberRequired
The value for which you want to calculate GAMMALN.
GAMMALN examples
Formulas you'll actually reuse.
ln Γ(x) — for x = 6 this is ln(120), i.e. ln(5!):
=GAMMALN(B2)Result
4.7875A factorial via the gamma function — works for non-integers too:
=EXP(GAMMALN(B2 + 1))Result
120
GAMMALN in Google Sheets
Same name — your formula ports as-is.
Try GAMMALN in the playground
Edit the example — nothing to install.
Preloaded with the GAMMALN 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
- GAMMALN.PRECISEReturns the natural logarithm of the gamma function, Γ(x)StatisticalGoogle Sheets