View Single Post
  #2   Report Post  
Dana DeLouis
 
Posts: n/a
Default

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!