Nth Root

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

Can someone tell me how to set up an equation to
calculate the nth root of something. In other words, I
have an equation that currently looks like
this: .8*1.1^2.33=1 The problem is that "2.33" is what
I want to solve for. In excel, my formula looks like
this: (1-B5)*(1+$D$4)^(G5) = 1. But, I want to solve
for cell G5 instead of solving this to get to 1. How do
I rearrange this algebraic equation so that I can enter
it in excel? Many thanks.
 
. . . In excel, my formula looks like
this: (1-B5)*(1+$D$4)^(G5) = 1. But, I want to solve
for cell G5 instead of solving this to get to 1. How do
I rearrange this algebraic equation so that I can enter
it in excel? Many thanks.
Click to expand...

If you want to solve for an exponent, you need to take logarithms of both sides
of the equation.
 
Back
Top