LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johnhax
 
Posts: n/a
Default Age and Number Years of Service

I am trying to write a formula that is able to return the earliest possible
year of retirement based on years of service and age. The conditions are
summarized in the following table:

Age Years of Service
2005 60 36
2006 60,5 36,5
2007 61 37
2008 61,5 37,5
2009 62 38
2010 62,5 38,5
2011 63 39
2012 63,5 39,5
2013 64 40
2014 64,5 40

To retire in any given year, someone must simultaneously meet the two
conditions. An example, for someone to retire in 2009 they must be at least
62 years old and have 38 years of service.

Any ideas?

Thanks in advance!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"