This is not complete but will go someway to what you are trying to achieve.
In E2 and going down enter the first lowest number of the apps, e.g. 60, 65, 75,85,95,105
In C2 enter
=VLOOKUP(B2,E2:G7,3)
and copy the formula down the column
As you change a value in column B the salary will change accordingly
Bookmarks