Linear interpolation with Excel

[TobiasL]

Hey guys,

how can I find the value of "i" within the formula below, with a linear interpolation in Excel?

thx
Tobi

 

[PaddyD]

hi - welcome to the board.

In general, posts of the form:

"I've got a non-excel maths problem - starting from scratch can you give me the excel solution?"

...generate the concern that we're being asked to do homework, which isn't really what he board is for. To dispell that thought, care to give some info on what you've tried so far etc...

 

[TobiasL]

Oh sorry about that!

I just dont know where to start. I know I have to guess a range where the value can lie and then try to come closer to that value.

Is there any function in excel that can help? I heard about the "TREND" function...

thx

 

[TobiasL]

hey I got it to work!

but is there are more easy way in Excel? Is there any function?

thx

 

[TobiasL]

no ideas?

 

[PaddyD]

have a read of this:

http://www.tushar-mehta.com/excel/newsgroups/interpolation/index.html