Interpolation Problem

[amirstal]

Let's say I have 2 values: one at F1 and the other at F8.
By using linear interpolation I can solve for F2, F3, F4, F5, F6 and F7
(the two other values that are needed for the interpolation are not
relevant for my problem).

Problem:
The two values that I have are not always in F1 and F8.
They now can be at F2 and F7.

Question:
How can I apply the interpolation without knowing where exactly my two
values appear? I do know for sure that I have two values and that there
are cells in between those two values that are needed to take
interpolated values...

I hope I am clear.

Thanks.

 

[amirstal]

I guess I was not clear enough, so I'll try again.
This is what I have now:
B C
2 12/19/2006 0.999706
3 12/20/2006
4 12/21/2006
5 12/22/2006
6 12/23/2006
7 12/24/2006
8 12/25/2006 0.998675

I can solve for C3, C4 etc.

But when I open my excel tomorrow, for example, the number in C2 might
be now in C3 and the one in C8 might go to C7. In this case I will
still want to solve for anything that is between a number above and
below...

Thanks.

 

[Bernie Deitrick]

Perhaps you can use:

=MAX(C2:C8)

and

=MIN(C2:C8)

HTH,
Bernie
MS Excel MVP