Nth Root

[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.

 

[Harlan Grove]

. . . 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.

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

 

[Peo Sjoblom]

The nth root is

=Value^(1/n)

is the same as

=POWER(Value,1/n)

 

[Jason]

Thanks everyone for the help.