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

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top