Double interpolation

[T Boucher]

Power.jpg
I must write a double interpolation formula for the table. Please help!

[ben_hensel]

Mathematically, this is a bilinear interpoliation, so the formula are there for you.

I'd use INDEX(MATCH) constructions to find the specific values to feed into those formulas up there into an intermediate table.

Post an example spreadsheet and I (or someone else) will be able to plop the formulas in and turn it around for you.

[shg]

If you can use a user-defined function, post a workbook instead of a picture.

[T Boucher]

Thank you!

[ben_hensel]

Here. Through an intermediate table, and I ended up naming the values you were interpolating between because that made my life easier, but this should grind out what you want.

Outside-range values are easily diagnosed because it throws errors in the intermediate table when you go off the edges.

[T Boucher]

Thank you very much!

[shg]

Nice work, ben.


Alternatively, a UDF.

[Prithvi10]

Thank You!

[AliGW]

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread