Hi, hoping someone can help me. I have a excel file that tracks completion rates and has lots of formulas but there is one that I cannot figure out.

I want a formula that will display "not completed in time" (for example) if completion isn't 100% by the planned completion date. The problem I have is that I want to have a record of this and if the completion rate becomes 100% after the planned completion date it will no longer show "not completed in time". Is there a way to setup a formula that will show data in a cell if the formula has EVER met certain criteria. Hope I'm making sense.