+ Reply to Thread
Results 1 to 46 of 46

Redundancy Calc with a difference - a formula question.

  1. #1
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Redundancy Calc with a difference - a formula question.

    Hi All,
    Not been around for a while, but when I'm flummoxed, I know there is only one place to turn! I wonder if someone could offer some assistance please.

    I've seen people doing your classic UK redundancy calculations on here before and I have built the redundancy calculator at my current job, however they have an ask of me and I am not sure how to do it, formula wise.

    For arguments sake (not at my work machine right now) let's say that you get a redundancy pay-out as follows

    0.5 weeks pay for each full year worked when you're under 22
    1 weeks pay for each full year worked when you're between 22 and 41
    1.5 weeks pay for each full year worked when you're 41 or older

    I have a date of birth, a hire date and an exit date. My goal is to complete this table using a formula to count how many times a person gets each "increment".
    Weeks at 0.5 = X
    Weeks at 1.5 = Y
    Weeks at 1.75 = Z

    I use the "Ready reckoner" to get the total weeks, but I want to get the breakdown. So I'll have e.g. 3 weeks in total, 3 x 0.5 and 1x 1.5

    Thanks all
    THU
    Attached Files Attached Files
    Last edited by TheNewUnion; 08-20-2024 at 05:14 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    Thanks for the workbook, however it is missing expected results for the sample data. See the last section in bold in my previous post.

    Thank you.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    Just to clerify what I want, could you at the very least tell me what results (values) you are expecting in the cells in blue?

    I could interpret your requirements several different ways and come up with various answers - I need to know what you're expecting so that I can test possible solutions.

    Also, you said you had DoBs - where are they/will they be?

    Please respond in a new post to this thread - we don't get notifications when previous posts are edited.

    AliGW on MS365 Beta Channel (Windows 11) 64 bit

    A
    B
    C
    D
    E
    1
    WRK 1 WRK 2 WRK 3 WRK 4
    2
    Exit Date
    31-Dec-23
    01-Apr-24
    04/04/2024
    31/01/2024
    3
    Age at Exit
    49
    25
    48
    48
    4
    Complete Years (12 Months from hire date)
    7
    7
    11
    30
    5
    Total Weeks
    10.5
    5
    14.5
    23.5
    6
    Weeks at 0.5
    7
    Weeks at 1
    8
    Weeks at 1.5
    Sheet: Sheet2

  5. #5
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    Can you delete the thread please, I'm struggling to effectively articulate the output. I will re-post once I can do so.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    No, there's no need for that (in fact we don't allow it).

    When you feel you can provide enough information for us, please just post again to the thread and this will bring it back to the top of the forum.

    All I was asking for, though, were your expected results.

    Thank you.

  7. #7
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    Thanks, that's the challenge I've been having. I know what the (final, total) output should be, and have a calculator that can get that it but it's articulating how the calculation gets there that's the challenge.

    In the example above, WRK 1 would have 7 x 1.5 Weeks as they have 7 full years at 42 years and above. I'll get my pen out and get it straight in my head and then I will "bump" the thread with further details, including a new upload.

    Thanks for your understanding.
    Last edited by TheNewUnion; 08-20-2024 at 07:16 AM.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    That's perfect - thanks.

  9. #9
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2019
    Posts
    3,947

    Re: Redundancy Calc with a difference - a formula question.

    Here is a sample for you.

    With [Age Started Work] at F6, [Years Worked] at G6 and [Age at Exit Date] at H6.
    X at I6: =MAX(0,INT(MIN(H6,21)-F6))
    Y at J6: =MAX(0,INT(MIN(H6,41)-F6)-I6)
    Z at K6: =INT(G6)-I6-J6
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    I thought I'd replied? Oh well.

    Thanks for taking a look. I will test and see what's what. I know I didn't post in the correct manner, been a while since I have been over here, so thanks again.

  11. #11
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91
    Quote Originally Posted by josephteh View Post
    Here is a sample for you.

    With [Age Started Work] at F6, [Years Worked] at G6 and [Age at Exit Date] at H6.
    X at I6: =MAX(0,INT(MIN(H6,21)-F6))
    Y at J6: =MAX(0,INT(MIN(H6,41)-F6)-I6)
    Z at K6: =INT(G6)-I6-J6
    I've been able to do some testing and it's almost perfect.

    I've got the full detail I needed now and the method works for everyone bar some who were hired at 40, but not yet reached 41.

    Would you mind taking a look if I upload a sample later today, with the examples which fail the validation please?

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    Someone will certainly have a look. I think that you might need a DoB field after all.

  13. #13
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    Hopefully this example makes sense. The solution is very close, hopefully a small tweak will solve.
    Attached Files Attached Files

  14. #14
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    In I9:

    =ROUND(MAX(0,MIN(H9,22)-F9),0)

    In J9:

    =ROUND(MAX(0,MIN(H9,41)-F9)-I9,0)

    Using ROUND instead of INT seems to work. 23 is wrong - changed back to 22. Please test it on other rows yourself.
    Last edited by AliGW; 08-22-2024 at 03:28 AM. Reason: Typo fixed.

  15. #15
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    Thank you. I will take a look shortly and report back

  16. #16
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    Tested, absolutely superb bar one result. I've noted the expected outcome in the attached.

  17. #17
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    Try this.

    I5:

    =ROUND(MAX(0,MIN(H5,22)-F5),0)

    K5:

    =IF(H5<41,0,INT(H5)-41)

    J5:

    =INT(G5)-I5-K5
    Last edited by AliGW; 08-22-2024 at 04:53 AM. Reason: Typos fixed.

  18. #18
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    thank you, I think you have cracked it! I'm going to throw a few more examples through it to double check.

    I like the approach of working out the "extremities" first, then using them to calculate the 1 x Weeks bit - very smart!

  19. #19
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    In fact, I5 can be this:

    =IF(F5>22,0,22-INT(F5))

    All much simpler.

    I like the approach of working out the "extremities" first, then using them to calculate the 1 x Weeks bit - very smart!
    It's the only way to balance the books!

    If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

    Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

  20. #20
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    Just in case you are interested, it can be done without the x, y and z columns:

    Please Login or Register  to view this content.

    AliGW on MS365 Beta Channel (Windows 11) 64 bit

    B
    C
    D
    E
    F
    G
    H
    I
    J
    4
    Employee Name
    DOB
    Hire Date
    Exit Date
    Hire
    Worked
    Exit
    Years
    Weeks
    5
    Empl 001
    30/09/1990
    09/03/2009
    13/08/2024
    18.44
    15.43
    33.87
    15
    13
    6
    7
    Empl 002
    22/03/1974
    04/01/2008
    31/10/2024
    33.78
    16.83
    50.61
    16
    20.5
    8
    9
    Empl 003
    18/04/1980
    27/07/2020
    31/12/2024
    40.28
    4.43
    44.70
    4
    5.5
    10
    11
    Empl 004
    03/04/1969
    25/06/2008
    06/03/2025
    39.23
    16.70
    55.93
    16
    23
    12
    13
    Empl 008
    21/07/1990
    03/12/2012
    30/11/2024
    22.37
    11.99
    34.36
    11
    11
    Sheet: Sheet1

  21. #21
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    Thank you so much, I'm calling this solved!

    I will have a look at the solution with LET, not something I have used yet but I think it will be good to know.

  22. #22
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    Just an Easter Egg!!!

    Glad to have helped.

  23. #23
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    Curses! Just one weird anomaly turned up.

    DOB 28/01/1966
    Hire 21/04/2008
    Exit 31/12/2024

    This shows 0 at 0.5 which is right, -1 at 1 which is incorrect (should be 0) and 15 at 1.5 which is incorrect (should be 16)
    Last edited by TheNewUnion; 08-22-2024 at 06:25 AM.

  24. #24
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    58-41 is 17 - how do you arrive at 16??? It shows 17 for me, not 15.

    Oh, wait - I've worked it out. Give me a mo!
    Last edited by AliGW; 08-22-2024 at 06:23 AM.

  25. #25
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    Apologies, typo from me. I'm sorry!

  26. #26
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    K5:

    =if(h5<41,0,int(h5)-if(f5>41,int(f5),41))

    SPILL formula:

    Please Login or Register  to view this content.

  27. #27
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    Is this resolved now?

  28. #28
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    I think so, I really appreciate your help here. This is super stuff.

  29. #29
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    No worries.

  30. #30
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    So sorry to have resurrected this again. I have run into another problem. I think it is because we need to calculate for full years service and some cases there is not e.g. a full years service at the termination date.

    I have uploaded a further sample. I think I may be able to live with it if it's not possible as I can flag errors for manual intervention, but though I would have one last ask.

    I really appreciate your expertise on this.

  31. #31
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    Sorry - I am out of ideas.

  32. #32
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    OK, thank you for all your help. I will mark as solved and see if any inspiration hits me. I think it is something to do with the FULL years between hire and exit date, so I will pursue that line of enquiry.

    Thanks again for all of your help, it's very much appreciated.

  33. #33
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    I wouldn't mark it as solved yet - there are lots of other contributors here!

  34. #34
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2019
    Posts
    3,947

    Re: Redundancy Calc with a difference - a formula question.

    My original formula is correct.

    Your expected results in post #16 are incorrect.

    Take Empl 005 at row 11: X should be 2, not 4. If 4, then age at X is 22.4, well past the age of 21.
    Attached Images Attached Images
    Attached Files Attached Files

  35. #35
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    I will have another look, apologies if I incorrectly reported an issue. It certainly wasn't intended to be a slight.
    Last edited by TheNewUnion; 08-27-2024 at 03:44 AM.

  36. #36
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    Please do check your requirements absolutely rigorously before posting again. We aren't ever going to be able to meet your requirements if your underlying calculations are not correct. Take your time - we'll still be here when you've done that.

  37. #37
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    I believe that my uploaded template is correct, indeed AliGW offered a solution which correctly calculated the samples given as per my expected results.

    I found the original solution incredibly helpful and I do appreciate there was a gap between me asking and me uploading the sample file.

  38. #38
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    So we are no further on. I take it you disagree with Joseph's post#34?

    You rejected my solution in post #30.

    I'm not sure what more we can do to help. Please advise.

  39. #39
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2019
    Posts
    3,947

    Re: Redundancy Calc with a difference - a formula question.

    Based on my post #34, taking Empl 005 as an example, can you explain why X should be 4?
    Last edited by AliGW; 08-27-2024 at 05:42 AM. Reason: Error corrected.

  40. #40
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    I disagree that there should be 2 x 0.5 in post 34, yes.

    You solution has been incredibly helpful, and in almost all cases returns the expected values. There are a couple of edge cases where the solution in Post #30 resulted in a negative value in one of the columns which was incorrect.

    I can add an additional post later, which can include a "ready reckoner" which returns the total number of weeks payable so the correct total is absolutely clear. I'm happy to do that and I do really appreciate all the help that has been offered up to now.

  41. #41
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    I disagree that there should be 2 x 0.5 in post 34, yes.
    Why? Explain your own calculation - why should it be 4?

    21-18.44=2.56

  42. #42
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2019
    Posts
    3,947

    Re: Redundancy Calc with a difference - a formula question.

    Quote Originally Posted by TheNewUnion View Post
    I disagree that there should be 2 x 0.5 in post 34, yes.

    You solution has been incredibly helpful, and in almost all cases returns the expected values. There are a couple of edge cases where the solution in Post #30 resulted in a negative value in one of the columns which was incorrect.

    I can add an additional post later, which can include a "ready reckoner" which returns the total number of weeks payable so the correct total is absolutely clear. I'm happy to do that and I do really appreciate all the help that has been offered up to now.
    Where is the explanation?

  43. #43
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    Give me a minute eh? I'm working on it.

    Apologies, that was a bit harsh
    Last edited by TheNewUnion; 08-27-2024 at 07:54 AM.

  44. #44
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    This should, hopefully, clear up the matter.

  45. #45
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2411 (Windows 11 23H2 64-bit)
    Posts
    88,072

    Re: Redundancy Calc with a difference - a formula question.

    21-18.44 still doesn't equal 4 ... So, no, it hasn't cleared anything up for me - sorry.

    And it now seems to have changed to 22. If it's 22, it's 3 full years; if it's 21, it's 2 full years.
    Last edited by AliGW; 08-27-2024 at 09:34 AM. Reason: Workbook added.

  46. #46
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    91

    Re: Redundancy Calc with a difference - a formula question.

    Thank you for taking another look. I do appreciate it.

    The "Ready Reckoner" correctly shows that 15 full years service at 33 years of age is 13 Weeks, comparing that to the link in the file for the Government calculator we also get 13 weeks.

    Having re-read everything in this thread, I think the difference lies in that the higher rates only apply for the full years you were over 22 or 41.

    If you turned 22 or 41 while working for your employer, the higher rates only apply for the full years you were over 22 or 41

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Time Difference Calc one day to the next
    By dubcap01 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-30-2020, 09:51 PM
  2. Repeating calc based on difference between two numbers
    By rfcomm2k in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-05-2016, 05:40 PM
  3. calc the average difference between columns
    By Zeke43 in forum Excel General
    Replies: 9
    Last Post: 05-05-2009, 05:35 PM
  4. [SOLVED] How do I create formula to calc difference in dates?
    By dlcroswell in forum Excel General
    Replies: 1
    Last Post: 08-17-2006, 07:35 PM
  5. Calc minutes and seconds difference
    By Coach in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-28-2006, 10:40 AM
  6. [SOLVED] Percentage difference calc that knows the largest figure
    By Mighty Magpie in forum Excel General
    Replies: 3
    Last Post: 11-10-2005, 02:45 PM
  7. Formula question - time calc
    By Steve Grosz in forum Excel General
    Replies: 5
    Last Post: 07-08-2005, 07:05 PM

Tags for this Thread

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