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 i...
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?
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.
- This was perfect. I figured out the one small change in the formula i needed but it works perfectly now. I couldn't have done it without you.
V/R
BillWilliam_Palmer , glad to help