Re: Reversing POWER Formula

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" <bob.phillips@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23o$2TSofFHA.1416@xxxxxxxxxxxxxxxxxxxxxxx
> 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)
>
>
> <soroosj@xxxxxxxxxx> wrote in message
> news:1120227014.922912.252100@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> Thanks for above responses. This is exactly what I needed!
>>
>
>


.

Relevant Pages

  • Re: Formula for a range of percentages
    ... > HTH ... > (remove nothere from the email address if mailing direct) ... thank you for the responses! ...
    (microsoft.public.excel.misc)
  • Re: Alias for file name.....
    ... (remove nothere from the email address if mailing direct) ... > I have a long log file where I pull only 10 of the columns and combine ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Range names -VBA
    ... What is wrong with the responses given yesterday? ... HTH ... (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.programming)
  • Re: sum if dates conditional
    ... we do it all the time in responses here. ... HTH ... (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.programming)
  • Re: column to column conditional formatting wont work, need formula
    ... HTH ... (remove nothere from the email address if mailing direct) ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)