Opps!!

Should be:


=((1+((1+C1)^(1/(A2-A1))-1))^365)


=318.868
Don

"Don" wrote in message
...
Sat-Geek

You seem to be happy with the results, however if you are using your
example of 10% over 30 days , the coumpound annual rate is more like:

318.868%

=((1+((1+A3)^(1/(A2-A1))-1))^365)

Don






"Sat-Geek" wrote
in message ...

:) Well Da!!

That fixed it! 1376.22% !!

A few years like that and I'm ready to retire!!

Thanks a lot

Sat-Geek


--
Sat-Geek
------------------------------------------------------------------------
Sat-Geek's Profile:
http://www.excelforum.com/member.php...o&userid=37091
View this thread:
http://www.excelforum.com/showthread...hreadid=568196