Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Elegant solution for two comparisons
I have a list of employees. Employees have salaries, and they have
grades (A through G). I'd like to tie their salaries and grades to a separate table of grade points. Here's an example of the table: Grade G / Grade F / Grade E 6 14,000 / 16,000 / 18,000 5 12,000 / 14,000 / 16,000 4 10,000 / 12,000 / 14,000 So I'd start with an employee with a salary of 14,000. He's Grade F. So the formula would output point 5. If he was Grade G, he'd instead be on point 6. What's the most elegant way to build this? Match and Index (which I'm not familiar with)? Nested IFs? Thanks, Joe. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there an elegant way? | Excel Discussion (Misc queries) | |||
Is there an elegant solution to this table? | Excel Discussion (Misc queries) | |||
More elegant way to do IF () | Excel Worksheet Functions | |||
Working Hours (formula & graph) - any elegant solution? | Excel Worksheet Functions | |||
More elegant method? | Excel Worksheet Functions |