Menu
EXCEL GAMMALN.PRECISE FUNCTION
Excel GAMMALN.PRECISE Function Introduction
Excel Gammaln. The Precise function computes the natural logarithm of the Gamma Function (n). Because the function is new in Excel 2010, it is not available in previous versions of Excel. The Gammaln.Precise function, on the other side, is merely an upgraded version of the Gammaln function, which was accessible in older versions of Excel.
Description of Excel GAMMALN.PRECISE Function
Syntax :
=GAMMALN.PRECISE( x )
Parameters :
The following parameters are :
- Where x is the positive numeric value at which the function should be evaluated
Step By Step Guide of GAMMALN.PRECISE Function
Example :
The graph on the right depicts the natural logarithm of the Gamma Function, (n), with x values ranging from 0 to 10.
If you wish to find the value of this function at x = 4.5, use the Excel Gammaln function.
As seen below, the Precise function may be used to do this:
=GAMMALN.PERFECT ( 4.5 )
This yields the answer 2.453736571.
Key Points
- #NUM! – Occurs if the value of x given is 0.
- #VALUE! – Occurs if the given x value is not a number.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
