FACT function

FACT Function in Excel helps you calculate the factorial of a given number. In simpler terms, it finds the product of all positive integers from 1 to the specified number. It is a useful tool for various mathematical and statistical calculations.




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

How to Use

Using the FACT function in Excel is straightforward. You provide the function with the number for which you want to calculate the factorial, and it returns the result. Here’s how you can use it:

Suppose you want to find the factorial of 5.

This formula will return the result:

It’s important to note that the FACT function only works with non-negative numbers. If you provide a negative number as an argument, it will result in an error. Additionally, the FACT function is limited by the capabilities of Excel, so it may return an error for very large numbers.


Let’s explore a few more examples to better understand how the FACT function works:

1. Calculate the factorial of 0 (0!):

This will return:

2. Calculate the factorial of 3 (3!):

This will return:

3. Calculate the factorial of 10 (10!):

This will return:

4. If you try to calculate the factorial of a negative number, such as -5:

This will result in an error.

Additional Information

The factorial function is often used in mathematics, statistics, and combinatorics. It represents the number of ways to arrange a set of items. Be cautious when using the FACT function with very large numbers, as it may exceed Excel’s computational limits and return an error.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.