SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / GAMMA
In This Topic
    GAMMA
    In This Topic

    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!