Interpolating data

[ebill]

I have a table with data as such:

xxxxx 93.00% 94.00% 95.00%
-5.00% 40.00% 25.00% 0.00%
-2.50% 75.00% 55.00% 40.00%
0.00% 110.00% 90.00% 70.00%


I need to interpolate the data. For example, I'd like to use a simple function to find when column is -2.75% and row is 94.5% then x = ?. Hope this makes sense. What function should I use? I prefer to avoid macros if possible.

[arthurbr]

Hi and welcome to the board
I don't understand what you are trying to do; Average values?

[shg]

You could use this function (goes in a code module):

Please Login or Register  to view this content.

In your example,

Please Login or Register  to view this content.