I think you are assuming that we know what all this data means.
Are you asking this:
Here is a table of weights and corresponding upper and lower limits for where the center of gravity can occur relative to fore and aft
Here is a weight and the center of gravity. Does that center of gravity fall within the limits for that weight?
Here is a solution using linear interpolation. Plotting a chart will help visualize it but won't help with the calculation. It calculates a table showing above, below, and interpolated values for the target. This could all be done with one large formula, but I think this gives more visibility to the user as to what's going on instead of just a bottom-line answer. The number is colored green or red depending on whether it is in range of the interpolated values.
Also I recommend you get rid of the merged cells. They are nothing but trouble.
Bookmarks