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