Most efficient way to apply bandings to employee list

Looking to apply the bandings below to employee list depending on what salary is and whilst I know could do this by using combination of IF and AND statements I'm thinking there must be a more efficient way to do this calculation wise - any tips or suggestions would be much appreciated.

Tagged:

Best Answer

Answers