Finding unknown variable (n) - time period - through excel.

[gjergj]

Hi everyone,

Was trying to figure out the below equation on how to turn it in order to find the missing variable but seems mission impossible for me. I think it should be somehow turned to a logarithmic one but i am not sure.

Either way, I was hoping excel could help into solving this issue. I have seen that many use it for equations too but never get the chance to use that and the videos in youtube are a bit for easy things.

I want to find (n) value which is the time to reach breakeven point in the above equation. Any ideas or suggestions? thanks a lot

 

[gjergj]

You could probably use Goal Seek instead of Solver.

Thanks for the suggestion. That worked too if I would organize the data as joeu2004 suggested.