FACT function

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

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)

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.