pension

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

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

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

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

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

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