help with power formula

[novxiv]

hi guys,

I have this formula:

M = ( r + ( r / ((( 1 + r)^t) - 1))) * P

M, r, t, and P are all variables.

Now if I want to find out "t". What would the excel formula look like?

Thanks in advance.

 

[diddi]

its a bit ugly...

mathematically i think its:

log[1 + (pr/(m-rp)] / log(1 + r)

 

[novxiv]

thanks diddi. anybody wanna to help us transform this to an excel formula?

anyone? everyone?...

 

[diddi]

log[1 + (pr/(m-rp)] / log(1 + r)

=(log(1 + (p * r)/(m - r * p)) / log ( 1 + r)

 

[novxiv]

Diddi thanks for hangin with me. May u pls review the formula again. I think a ")" is missing...

 

[novxiv]

didi,

thanks for your help.

/code

=(log(1 + (p * r)/(m - r * p))) / log ( 1 + r)

//code

i just added the missing ")" to ur formula. sorry I am too tired to think and evaluate ur awesome formula. but it work!

thanks again