The FACT function calculates the factorial of a number, which is the product of all positive integers up to and including that number. This function is commonly used in mathematics and statistics to calculate permutations and combinations.



number The non-negative number for which you want to calculate the factorial.

About FACT

When you find yourself in need of swiftly calculating factorials in Excel, the FACT function emerges as your go-to assistant. This function performs the heavy lifting of determining the factorial of a given number, paving the way for seamless computations in mathematical and statistical analyses. Factorials play a crucial role in permutations, combinations, and various mathematical operations, making FACT a versatile tool in your Excel arsenal.

To unleash the power of FACT, simply provide the desired number for which you seek the factorial. Whether you're exploring permutations for a complex problem or analyzing the combinatorial aspects of a dataset, FACT simplifies the process by swiftly delivering the factorial value.

One of the key attributes of FACT lies in its efficiency. With minimal effort, you obtain accurate factorial values, eliminating the need for manual calculations and streamlining your mathematical endeavors within Excel.

In essence, FACT stands as a reliable ally for swiftly computing factorials, facilitating intricate mathematical computations with ease.


If you want to calculate the factorial of 5, you would use the following formula:
This will return the factorial value of 5 which is 120.

To find the factorial of 7, you can use:
Excel will return the factorial value of 7 which is 5040.


What is a factorial and how is it calculated by the FACT function?

A factorial is the product of all positive integers up to a given number. For example, the factorial of 5 (5!) is calculated as 5 x 4 x 3 x 2 x 1 = 120. The FACT function automates this calculation in Excel.

Can I calculate factorials for decimal numbers using the FACT function?

No, the FACT function is designed to calculate factorials for non-negative integers. It does not support decimal numbers or fractions.

What happens if I input a negative number into the FACT function?

The FACT function will return an error if a negative number is provided as input, as factorials are not defined for negative integers.

Related functions