ISBLANK formula within IF formula
I am wondering how to incorporate an ISBLANK or any other solution into the below IF formula to overcome the issue I am having. The issue is that if Date 82 is blank, then it is automatically giving "Operational" instead of continuing the evaluation of the IF statement. There are no dates entered in either Date 82 or Date 72, so I want it to return a value of "In Development."
=IF(TODAY() > Date82, "Operational", IF(TODAY() > (Date82 - 60), "Pre-Operational", IF(TODAY() > Date72, "Under Construction", "In Development")))
All help is appreciated.
Help Article Resources
Check out the Formula Handbook template!