A 1-Cell entry along this same theme might be something like this:

=SUMPRODUCT(LOG(ROW(INDIRECT("1:229"))))

--
Dana DeLouis
Win XP & Office 2003


"Jay" wrote in message
8.16...
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 ?


Recall that LOG(A*B) = LOG(A) + LOG(B)

So LOG(FACT(229)) = LOG(1)+LOG(2)+...+LOG(229)

In A1:A229, put
=LOG(ROW())

Then in B2 put
=SUM(A:A)