Hi everyone,
I have a spreadsheet of employees that shows their current pay grade and their current salary. We have created a new pay system with 14 steps within each pay grade. We need a formula that will lookup the correct grade and calculate the step that is closest to their current salary (must be higher than their current salary) plus one. I have tried lookups, INDEX and MATCH formulas and even the LARGER formula, but all I get is errors. Can anyone help? I have attached some sample employee data (Employee List worksheet) and a copy of the pay grades and steps (Pay System and Steps worksheet).
Thanks!!
Nanci
Bookmarks