How to Use the GAMMALN Function in Excel

This guide explains how to use GAMMALN Function in Excel, including its syntax, required arguments, practical examples, and common errors.

Description: The function returns the natural logarithm of the gamma function, Γ (x).

Syntax: GAMMALN (x)

Inside:

- x: The value you want to calculate the natural logarithm of the gamma function, Γ (x). .

Attention:

- If the function's x value is not numeric -> the function returns the #VALUE! Error value

- If x ≤ 0 the function returns the #NUM! Error value

- The exponent e of GAMMALN (i), i is an integer, returns the same result as (i - 1)!.

- The function is calculated as follows:

[GAMMALN = LNleft ({Gamma left (x right)} right)]

Inside:

(fleft (x right) = left {{begin {array} {* {20} {c}} {0,,,,,,, {rm {if}}, x <0} {x,,,, { rm {if}}, 0 le x le 1} {1,,,,,,,, {rm {if}}, x> 1} end {array}} right.,)

For example:

Calculate the natural logarithm value of the gamma function, Γ (x) of the values in the following data table:

- In the cell to calculate enter the formula : = GAMMALN (C6)

- Press Enter -> the natural logarithmic value of the gamma function, Γ (x) is:

- Similarly copying the formula for the remaining values results:

Where x ≤ 0 -> the function returns the #NUM! Error value

Above are instructions and some specific examples when using the GAMMALN function in Excel.

Good luck!