Spread WPF 17
Spread WPF Documentation / Formula Reference / Formula Functions / FACT
In This Topic
    FACT
    In This Topic

    Summary

    This function calculates the factorial of the specified number.

    Syntax

    FACT(number)

    Arguments

    The argument can be any numeric value.

    Remarks

    The factorial is the product of the positive integers less than or equal to a number and is calculated as 1 x 2 x 3 x . . . x number, and is typically written as n! for n being the number. For example, 4! is 1 x 2 x 3 x 4, which is 24. The argument must be a non-negative number. If you provide a number that is not an integer for the argument, the decimal portion of the number is ignored.

    Data Types

    Accepts numeric data. Returns numeric data.

    Examples

    FACT(B3)

    FACT(R1C2)

    FACT(10) gives the result 3628800

    See Also