Hello I'm new to this forum.
In Sheet1 - I have a spreadsheet containing 5 employees containing basic employee details (eg Names, Base Salary and Grade).
In Sheet2 - There are five different salary ranges (columns as follows: MINIMUM SALARY, MAXIMUM SALARY, GRADE). The unique identifier is the Column "GRADE" which helps identifier which employee's salary is relevant to the list of salary ranges. Sheet1 also contains each employee's own grade.
in Sheet1, I wish to output:
Whether each employee's Base Salary is above the salary range threshold using the salary ranges from Sheet2
Which is the best formula to use in order to get the best output?
Many thanks
mramo
Bookmarks