FACT function

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?
 
J

Jerry W. Lewis

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
 
Top