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" <itsjay_97plus1_DoTheMath@yahoo.com> wrote in message
news:Xns96D3A5290F809qwertyuioplkjhgfdsa@207.46.248.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)