Forum Discussion

William_Palmer's avatar
William_Palmer
Copper Contributor
Jun 21, 2022
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...
excel
Formulas and Functions
training
William_Palmer's avatar
William_Palmer
Copper Contributor
Jun 21, 2022
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?
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 21, 2022

    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.

    • William_Palmer's avatar
      William_Palmer
      Copper Contributor
      Jun 21, 2022
      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

Resources