# if statement help! urgent!

#### DieArd

##### Board Regular
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

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### DieArd

##### Board Regular
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

Replies
3
Views
98
Replies
17
Views
189
Replies
3
Views
219
Replies
2
Views
400
Replies
1
Views
163

1,191,696
Messages
5,988,149
Members
440,131
Latest member
EricMoz

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back