if statement help! urgent!

[DieArd]

Hi All,
I ahev 10 misn to get this done.

=IF(D5="yes",0,IF(AND(D5="no",H5>=0.3),IF(K5<=10,K5,IF(K5>=11,K5*1.5,CHOOSE(K5-5,9,10.5,12,13.5))),""))

The formula basically says if someone is off sick they get paid nothing.
If they are not sick then they get paid £1 for every d/d(k5) added upto 10. Anything over they get paid £1.50

I want to amend it to: 1-10 £1 each 11-30 £1.50 each 31+ £2.50 each.


Can anyone help with this.

Thanks

 

[DieArd]

Hi All,
I ahev 10 misn to get this done.

=IF(D5="yes",0,IF(AND(D5="no",H5>=0.3),IF(K5<=10,K5,IF(K5>=11,K5*1.5,CHOOSE(K5-5,9,10.5,12,13.5))),""))

The formula basically says if someone is off sick they get paid nothing.
If they are not sick then they get paid £1 for every d/d(k5) added upto 10. Anything over they get paid £1.50

I want to amend it to: 1-10 £1 each 11-30 £1.50 each 31+ £2.50 each.


Can anyone help with this.

Thanks

still having trouble with this, any suggestions would be very apprciated