Math question

[robertdseals]

How would you solve this in Excel?
(1+x)^5 * 3 = 4.5

I don't know what to do with the power of 5.

I get (1+x) = 1.5 but then I don't know how to solve for X using Excel.

 

[wigi]

Hello

Do you put all constants in cells? If yes, what cells do you use - then I can write a formula that references the same cells as you do.

 

[robertdseals]

I'm trying to figure out what X is.
So I can get to (1+X)^5 = 1.5 but I need to come up with a way to get X = .084 (or whatever it is).

 

[wigi]

if you A1=5 and B1=1.5 then in C1:

=B1^(1/A1)-1

 

[robertdseals]

Ahhh! Yes! got it! thanks,
(1+x)^5)^(1/5) = 1.5^(1/5)