pension

  1. leopardhawk

    Need help with YEARFRAC

    Hello forum friends, would like to know if it's possible to convert a decimal to months of age. I have a formula that is returning "Started pension at 63.5222222222222 years of age" and I think it would look a lot better if it returned "63 years 6 months of age". The return does not need to...
  2. O

    Sumif Indirect

    I've scoured the forums and seen this posted before but I still can't get mine to work. Workbook: Pension Calculations. Formula= SUMIF(INDIRECT("$C8&""!$AH$3:$AH$691"),$A9,(INDIRECT("$C8&""!DK$3:DK$691"))) C8 = April2018 Sheet name is April2018 A9 = Employee Ref Numbers going down AH3:AH691 =...
  3. D

    Value error using sumifs/sumproduct

    I'm trying to sum columns/rows with multiple criteria using sumifs and sumproduct, but get value errors. My data table looks like this: <tbody> 1000 2000 3000 Total 1000 # Emp# Salaries Bonuses Pension Total Salaries Ben A 121 1568.98 500.00 (29.65) 2039.33 150.00 0.00 </tbody> My...
  4. N

    If this and that!

    Hi All, been racking my brains on this one, looked at loads of examples. I think I just do not understand the structure of combining the if and or statements as I have written it down and it makes sense to me. :laugh: Basically I am working out employer Pension contributions. The formula in my...
  5. R

    Pension Calculation Formula Required

    This problem has almost got me in tears! I need to find a formula to work out the answer to the following: Reckonable Service - 10 years 337 Days by Pensionable Salary - £18967.44 by 1/80th i have spent weeks on this trawled the Www bought books and I am now going mental. M PLEASE CAN...
  6. L

    Pension Formula - Please help...

    Hey there I have never posted before, but always read the forum and the help is amazing, but i'm i have one question myself, which i can't find the answer to. I need to work out a formula that provides the amount of pension costs we have to pay. ie. If salary is between 0 and £19,500 the...

Some videos you may like

This Week's Hot Topics

Top