Spread.NET 17 Formula Reference
Formula Functions / Functions D to G / GAMMA
In This Topic
    In This Topic

    This function calculates the gamma function value.




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


    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.


    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.