Hi
Slightly weird question and I'm hoping Excel is not going to let me down.
I've prepared an IF statement to show if a hourly rate of pay falls with a band of two pay rates and to return "YES" if it does and "NO" if it doesn't -
=IF(AND(R3>=T3,R3<=U3),"No","Yes")
If I get back "NO" I then...