+ Reply to Thread
Results 1 to 4 of 4

Calculate sick days

  1. #1
    Forum Contributor
    Join Date
    08-22-2008
    Location
    S-o-t
    MS-Off Ver
    Office 2000 & 2010
    Posts
    166

    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.
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: Calculate sick days

    Is this it:

    Sickness3(1).xls

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: Calculate sick days

    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...

  4. #4
    Forum Contributor
    Join Date
    08-22-2008
    Location
    S-o-t
    MS-Off Ver
    Office 2000 & 2010
    Posts
    166

    Re: Calculate sick days

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1