Ian's experimentation is consistant with the range of a double precision
floating point numer (what excel uses for calculating values)

lol.. sounds like you need a cray!!

Double Data Type


Double (double-precision floating-point) variables are stored as IEEE 64-bit
(8-byte) floating-point numbers ranging in value from -1.79769313486231E308
to -4.94065645841247E-324 for negative values and from 4.94065645841247E-324
to 1.79769313486232E308 for positive values. The type-declaration character
for Double is the number sign (#).


"Ian" wrote:

A little experimantation reveals that FACT(170) is the largest possible,
returning a value of 7.2574E+306.


--
Ian
--
"Rushi" wrote in message
...
Hi,

For some analysis I am doing, I tried the following LOG(FACT(229)), and it
returned NUM!. I am wondering if 229 is too big a number to compute a
Factorial of ? If so, is there an upper limit (something like FACT
function
can be applied for numbers <= 150) for the FACT function ?

Thanks in anticipation,

Rushi Patel