Interpolation on two axis in Mathcad 15
Dear all,
I have a (example) table like this:
| 1 | 2 | 3 | 4
--------------------------
5 | 11| 12 | 13 | 14
6 | 21| 22 | 23 | 24
Where the top row is A (values 1 to 4), the left column (values 5 and 6) is B and the field values (11 to 24) are Y.
Now I want to find the value Y belonging to A=2,5 and B=5,5 using linear interpolation.
Currently I have split the table into multiple small tables, one for each column, and then first create a new table for A=2,5 and then interpolate in that table to find the result for B=5,5.
This however takes a lot if programming to create the table for A=2,5 (as we have to first indicate which two tables to use based on the value of A).
Is there a direct way of doing this?
Thanks in advance for your replies.

