FACT

Formulas / FACT
Calculate the factorial of a number.
=FACT(number)
  • number - required, nonnegative number to factorial
  • factorial - equal to 1 * 2 * 3 * ... * number

Examples

  • =FACT(5)

    The FACT() function in Sourcetable is used to calculate the factorial of an integer. For example, the factorial of 5 is 120, which can be calculated in Sourcetable using the formula, which returns the result 120.

  • =FACT(1.9)

    The FACT function can also be used to calculate the factorial of a decimal number. For example, the factorial of 1.9 is 1, which can be calculated in Sourcetable using the formula, which returns the result 1.

  • =FACT(-2)

    The FACT function does not accept negative numbers, and will return an #NUM! error when used on a negative number. For example, the preceding formula will return an #NUM! error.


Summary

The FACT function is used to calculate the factorial of a given number. It is a powerful tool to quickly solve complex mathematical calculations.

  • The FACT function returns the factorial of a given number, which is the product of all positive integers less than or equal to the argument.
  • The argument must be a positive integer, and it is the only argument the function takes.

Frequently Asked Questions

What is the FACT function?
The FACT function is a mathematical function that calculates the factorial of a number.
What is a factorial?
A factorial is the product of all positive integers less than or equal to a given number. For example, the factorial of 5 is equal to 1 * 2 * 3 * 4 * 5 = 120.
How do I use the FACT function?
The FACT function takes one argument, the number you want to calculate the factorial of. You can use the function in a formula like this: =FACT(x), where x is the number you want to calculate the factorial of. For example, =FACT(5) would return 120.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV