Long IF formula to addon if more than 24 months, then TRUE is "Aged"

JoMoWasHere 

OK, I went in and looked. The first thing I tried was the IFS function and it was accepted. Maybe my subscription to Microsoft 365 is the difference? I'm not a Sharepoint user, but opened your file directly from the link IN Sharepoint......

Anyway I found myself unable to decipher what your conditions were and how they related to the data displayed.

• In the first line, the Renewal date is basically two years in advance of the Approval date
• In the second line, the renewal date is exactly 12 months after approval, yet the condition line reads "months 1-8 is 'Yes'"
• in the third line, there's one month from Approval to Renewal, but the condition description reads "months 9-12 is 'At Risk'"
• and so on.

Now, perhaps those lines aren't meant to line up; perhaps you're saying that the whole formula returns wrong answers in every case; I thought you were just trying to add the "Aged" condition but don't see where that meets any of your trial data.

But now that it looks like IFS does work, maybe you can resolve it yourself.

I'd be happy to help if you can come back and clarify what those conditions are and how they related to your trial data.