Home |
Search |
Today's Posts |
#7
![]() |
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |