Hi. What we're trying to say is that your equation may be correct. We just
want to point out that there seems to be a big difference from entering
0.5461% and returning 6.7542%. If you changed your equation slightly to
include the "/12" part...
=POWER(0.5461%+1,12)-1
to this..
=POWER(0.5461%/12+1,12)-1
You would get the same answer as
=EFFECT(0.5461%,12)
which would be 0.5475%.
Again, just thought we would mention it. :)
--
Dana DeLouis
Win XP & Office 2003
"Bob Phillips" wrote in message
...
You didn't answer Dana's question. I would be interested to know as well.
--
HTH
RP
(remove nothere from the email address if mailing direct)
wrote in message
oups.com...
Thanks for above responses. This is exactly what I needed!
|