Help with Excel Formula (IF OR with 3 conditions)

[jintang]

Hi

I would require assistance with the formula that I am currently working on. This formula is used in the summary page and it would reflect these 3 conditions
1. If the cell is empty, it will show "Not Completed"
2. If the cell is filled up, it will show "Done"
3. If the cell is highlighted in red (from conditional formatting), it will reflect "error" --> Conditional formatting set that if value is not within the range, it will be highlighted red.

Currently, I am able to use the IF OR formula for Condition 1 and 2, but I am stuck with Condition 3. Would like to seek help inserting this into my formula.

This is the formula that I used
=IF((OR('Daily BsC'!F6:F8="",'Daily BsC'!F10:F12="",'Daily BsC'!F14:F20="")),"Not Completed","Done")

Thanks.

Regards
Jin Tang

 

[jintang]

ah yes, it resolved the issue. just wondering if there is a permanent fix for this problem?

 

[Crystalyzer]

That is the "fix"