Calculate sick days

Hi

Please find attached a sample sheet of where I’m up to so far

If someone goes sick they will have waiting days before they get Company Sick Pay, depending on what they are entitled to, after that they get (SSP) in column C. I want W D, CSP or SSP.

The number of waiting days is in cell H2
The number of days someone is entitled to CSP is in cell G2

Hope someone can help

Dave.

Is this it:

Sickness3(1).xls

Also, I would like to refer to your formula in H2: =IF(I2<1;0;IF(AND(I2>0;I2<5);1;IF(AND(I2>4;I2<10);2;IF(I2>9;3))))

IF STATEMENT:

=IF(I2<1;0 <- this is ok
but now... no need to check if it's bigger than 1 Or worse, if it's bigger than 0, because IF I2<1 it will automatically do it:
So instead of
IF(AND(I2>0;I2<5)

it's enough to have
IF(I2<5;
etc...

=IF(I2<1;0;IF(I2<5;1;IF(I2<10;2;3))))

Last part... IF(I2<10;2;3))))

IF it's not less than 1, and not less than 5, and not less than 10 then it must be higher than 10...

IF(X<=1;"less or equal than one"; "Higher than one")

No need: IF(X<=1;"less or equal than one"; IF(X>1;"Higher than one")

Also.. if you have lot of IF statements maybe you could consider to use LOOKUP function:

=IF(I2<1;0;LOOKUP(I2;{1;5;10;xxx};{1;2;3;xxx}))
xxx is desired number...

Hi

My Problen isn't the formula's in d2:I2 but thannks for tidying them up

Its The formula in Column C at the moment i have made it input WD for a waiting day and CSP for company sick pay. I also need it to have SSP if The count of CSP has reached the Entitlement amount.
So no need for a Formula in G2 as That willl come from length of service in another sheet.