Hi All,

I am trying to figure out how to do what probably is an easy task, but I just "cant see the woods for the trees".

I have the variables as shown, the first two are factors that relate to the next two variables that are the upper and lower bounds for the first set of variables, the final variable is the actual height that the first 4 variables are to be used to obtain an interpolated value. Note that the number of rows can vary depending on the initial values, but all 5 variables will have the same number of rows.

On the LHS is the logic per row of each, the first IF is used to stop the divide by zero that will be found by the ELSE, when both rows are the same, I have attempted to do this in the grey box, but don't get the right (expected) answer. This should work for any number of rows in the variables

Can anyone please point me in the right direction?



Wind-test.sm (258 KiB) downloaded 35 time(s).

A bit of confusion with indexes
wind-test_s.sm (11 KiB) downloaded 46 time(s).
sergio

Wrote

A bit of confusion with indexes
wind-test_s.sm (11 KiB) downloaded 46 time(s).
sergio

So close, thank you. I will get all this programming one day!