mcintoshmc
Active Member
- Joined
- Aug 10, 2007
- Messages
- 277
This formula works, but if all cells are blank, it will show as completed because they are indeed equal to each other. How can I return a blank result, if all cells are blank?
=IF((AND($T17=$U17,$V17=$W17,$X17=$Y17)),"Completed","Not Yet")
=IF((AND($T17=$U17,$V17=$W17,$X17=$Y17)),"Completed","Not Yet")