Hi there,
I've been racking my brain trying to remember how to get the result I want.
In cells A1 to A5, they will either say YES or NO.
In A6, if all cells say YES then I want A6 to say COMPLETE
If some cells say YES & some say NO I want A6 to say ONGOING
I'm sure I'm missing something really simple.
TIA
Bookmarks