3 Replies Latest reply on Sep 19, 2016 1:27 PM by gkaiseril

    Help trying to calculate and/or interpret value from table data


      Trying to create a form field that would calculate / interpret a value to use for Rng based on given WT and Temp values.

      Ex.  At 20 degrees, and a WT of 20, my Rng will be 600.  At a WT of 15, my Rng will be 537.

      How can I use an array to help me calculate what my Rng value would be if my WT value falls anywhere in-between two of the listed WT values?

      Thanks in advance for any and all help.


      Screen Shot 2016-09-19 at 2.40.02 PM.png