Thread: Reversing POWER Formula
View Single Post
  #2   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default
On 30 Jun 2005 16:03:31 -0700, wrote:

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


=POWER(G2+1,1/12)-1

--ron
Reply With QuoteReply With Quote