Forum Discussion
Long IF formula to addon if more than 24 months, then TRUE is "Aged"
Without the actual spreadsheet, I'm not going to try to edit (without testing) a revised formula. I will be bold to suggest, however, that you research the IFS function, which is cleaner and clearer that deeply nested IF functions. You just need to be aware that basically it moves from left to right through the conditions and stops once a condition is met, so make sure you sequence the various combinations of condition/consequence accordingly.
It would, in your case, look something like this (broken up into multiple lines solely for clarity)
=IFS(
DATEDIF(TODAY(),E4,"Y")>2,"Aged",
E4<TODAY(),"No",
E4<(DATE(YEAR(TODAY()),MONTH(TODAY())+3,DAY(TODAY()))),"At Risk",
TRUE,"Yes",""
your new condition & consequence
)
P.S. It always helps if, rather than an image, you post a copy of the actual workbook/spreadsheet on OneDrive or GoogleDrive, with a link here that grants access.
- Appreciate the input and the feedback. Didn't think of actually put the file in GoogleDrive or OneDrive, it would be 1000x easier for help. Definitely will add it when I can and will try that formula out.
Unfortunately, the IFS function is not supported on SharePoint so I have to stick with IF statement for now.- Well then, put it here for us to help with the IF function. I just don't like having to create the underlying set of conditions to test a formula, and you clearly have a spreadsheet already.
- Don't blame you. Should be in the post as well
https://contracostahsd-my.sharepoint.com/:x:/g/personal/jmoral2_cchealth_org/EZKpM6GVFhZGkX37Fwoqyo8BUqu8AdhPtEqOtVayts8aig?e=vv6ANh
