# pension

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