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 want cell W3 to tell me how far outside the band the number is
e.g.
Current rate £10.00
Pay Banding £10.20 - £11.00 (In cells T3 & U3)
I want W3 to return the answer of "-0.20" but also if the current rate was "11.50" I'd need the answer to show as 0.50
Please help
Much appreciated
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 want cell W3 to tell me how far outside the band the number is
e.g.
Current rate £10.00
Pay Banding £10.20 - £11.00 (In cells T3 & U3)
I want W3 to return the answer of "-0.20" but also if the current rate was "11.50" I'd need the answer to show as 0.50
Please help
Much appreciated