Forum Discussion
Solved
How Do I do some complex calculating in Excel?
I am tracking many bits of data in a giant workbook. I need to do some complex formulas to determine retirement eligibility dates. What my team is looking for is if a person will be 53 or greater in the next 36 months and has more than 5 years of total service then the answer would be "YES". In the sheet i have date of birth, todays date, total time in dept
5 Replies
- Sergei
Thank you so much. I did leave out one factor which is uniformed personnel=yes, for this formula and uniformed personnel=no, for the age 65 and older formula. How do I add that into the mix?William_Palmer , you are welcome
Perhaps
=IF( ( YEARFRAC(B3,EDATE(TODAY(),36) ) > IF(D3 = "yes", 53, 65) ) * (C3 > 5), "Yes", "No" )if I understood the logic correctly. Please check attached.
