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.
C8 = April2018 Sheet name is April2018
A9 = Employee Ref Numbers going down
I'm trying to sum columns/rows with multiple criteria using sumifs and sumproduct, but get value errors. My data table looks like this:
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
i have spent weeks on this trawled the Www bought books and I am now going mental.
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...