# Pension Calculation Formula Required

#### Robin1957

##### New Member
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?

### 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
Can you give an example of what the input and the results should be?

#### MickG

##### MrExcel MVP
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 !!

#### Robin1957

##### New Member
How can 337 days be a fraction and 10 days be a full number?

#### MickG

##### MrExcel MVP
337 Days , as fraction of year = 337/365 = .923 Years, Plus 10 Years = 10.923 Years ??

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