FACT function

  • Thread starter Thread starter Kostas
  • Start date Start date
K

Kostas

Is there any chance to ypass the limit of the function
FACT. The upper limit is the value 170. Can we excess this
limit?
 
The 170! limit is not a limit on the FACT function, it is a limit on the
maximum number that Excel (and most other computer programs) can handle.
You can work around it with logarithms
=GAMMALN(n+1)
is ln(n!)

Jerry
 
Back
Top