Find Closest Value in Array

This is a formula that is used to compare the market value of a particular job against the midpoints in a grade structure.  This spreadsheet looks at the market value and returns the midpoint that is closest.

As a quick reference, the formula is: 


download sample spreadsheet