Pension Calculation Formula Required

Robin1957

New Member
Joined
Jun 11, 2013
Messages
4
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 ANYONE HELP ME TO FIND THE FORMULA?
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Momentman

Well-known Member
Joined
Jan 11, 2012
Messages
3,963
Can you give an example of what the input and the results should be?
 

MickG

MrExcel MVP
Joined
Jan 9, 2008
Messages
14,841
Does this sound too simplistic ??
337/365= 0.923 + 10 = (10.923 *18967.44)/80= 2589.835
I image any specific pension would also other criteria for calculation !!
 

MickG

MrExcel MVP
Joined
Jan 9, 2008
Messages
14,841
337 Days , as fraction of year = 337/365 = .923 Years, Plus 10 Years = 10.923 Years ??
 

Watch MrExcel Video

Forum statistics

Threads
1,095,931
Messages
5,447,371
Members
405,447
Latest member
WPY

This Week's Hot Topics

Top