Spread Formula Reference
GAMMA
Formula Functions > Functions D to G > GAMMA

This function calculates the gamma function value.

Syntax

GAMMA(value)

Arguments

For the argument, you can specify any real number whose value is either greater than 1 or equal to 1.

Remarks

The value passed in the arguments should not be a negative integer or 0. If the specified number is a 0 or a negative integer, this function returns the #NUM! error.

If the specified number possesses invalid characters, this function returns the #VALUE! error.

Data Types

Accepts numeric data. Returns numeric data.

Examples

GAMMA(7.5) gives the result 1871.254

GAMMA(1) gives the result 1

GAMMA(-1.23) gives the result #NUM!

Version Available

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