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...
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
Bill
V/R
Bill
William_Palmer , glad to help