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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there any place I can get screen shots of Outlook Web Mail screens with notations? 0
Default local file location - folder redirection slowness 0
Match Multiple Criteria & Return Numeric Labels across single row 8
How can i find the max value within a time range ased on two cells 6
Count Column B if Column A is within a multiple specificed ranges 2
Help with complex IF statement 1
Extend the number of arguments of a function 9
Limit to MOD function 2

Top