FACT function

Returns the factorial of a number. The factorial of a number is equal to 1*2*3*...* number.



Number     is the nonnegative number you want the factorial of. If number is not an integer, it is truncated.



Description (Result)


Factorial of 5, or 1*2*3*4*5 (120)


Factorial of the integer of 1.9 (1)


Factorial of 0 (1)


Negative numbers cause an error value (#NUM!)


Factorial of 1 (1)

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.