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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top