This function returns the inverse of the gamma cumulative distribution.

Syntax

GAMMA.INV(p,alpha,beta)

Arguments

This function has these arguments:

Remarks

This function calculates the inverse of the F probability distribution, so if p = GAMMA.DIST(x,...), then GAMMA.INV(p,...) = x. The standard gamma distribution is returned if beta = 1.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

GAMMA.INV(A3,3,4)

GAMMA.INV(0.8902,R3C8,R3C9)

GAMMA.INV(0.75,2,3) gives the result 8.077903586669088

Version Available

This function is available in Spread for Windows Forms 11.0 or later.

See Also

GAMMA