5 Replies Latest reply: Dec 26, 2011 8:02 AM by zsantiqlik RSS

    Interpolation between 4 possible values

      Hey, I need to get a value as a result of an interpolation in a double-entry table.

       

      The table is:

      - Column A

      - Column B

      - Column C

       

      By giving values to A and B, I need to calculate C.

       

      As in the double-entry table I have discrete values (ex: 5, 10, 15......) but I may need to get into the table with some other value (ex: 12,3), the result should be the consequence of an interpolation process between the four possible values.

       

      Here is an example

      example.JPG

      The result should be something between 6, 7, 12 and 17.

       

      The expression could be put in a Text Object.

       

      Thanks