Reversing POWER Formula

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

All,

Could someone with greater algebra skills help me with below formula?

Cell F2 contains 0.5461%
Cell G2 contains =POWER(F2+1,12)-1, which equals 6.7542%

I am trying to create a formula that reverses the above calculation. I
would receive cell G2 data from a system (6.7542%)and would need to
calculate in Excel non-annualized data in cell F2 (0.5461).

I remember tackling something like this many, many years ago but can't
quite summon the required math (perhaps a logarithm)?

Thanks in advance for any ideas.

Regards,
Joel
Using Excel 2003

.

Relevant Pages

  • Re: Reversing POWER Formula
    ... (remove nothere from the email address if mailing direct) ... > would receive cell G2 data from a system and would need to ... > calculate in Excel non-annualized data in cell F2. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Reversing POWER Formula
    ... Are you trying to calculate effective rate by chance in G2? ... Dana DeLouis ... > would receive cell G2 data from a system and would need to ... > calculate in Excel non-annualized data in cell F2. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Reversing POWER Formula
    ... >Could someone with greater algebra skills help me with below formula? ... >would receive cell G2 data from a system and would need to ... >calculate in Excel non-annualized data in cell F2. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: display first or second match instead of #REF in INDEX ROW for
    ... consider is that the formula is *already* fairly calculation intensive. ... My thought is to insert a row in the calendar sheet where I can ... If no match, then cell remains blank. ... Source worksheet has 2350 rows and 3 columns. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: MDX non-leaf level aggregation performance issues
    ... How come when I use NonEmptyCrossJoin in my write-enabled cube, ... If I update a cell and then issue ... You may want to carefully examine your calculation design to ensure the safe ... use of NonEmptyCrossjoin, or consider migrating to SQL AS 2005. ...
    (microsoft.public.sqlserver.olap)