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.
