trying to get a mathcad function that returns an rounded match from a table the example is attached, I could put the figures within a graph and use the interpret function but i want a rounded answer to the next D610.
i.e. for the attached sheet the solution would be 1.7m when the looking for an F of 27kNm in column F610 i.e. not an exact match, therefore selecting the higher value in column D610. i.e. in excel this would be a Vloop/match function.
Solved! Go to Solution.