I've got the following function that check if each cell has a date greater than TODAY(). If result is true, it'll display "NO GO". Otherwise, it'll display "GO".
I would want to improve on it such that if any of the 'B5:F5' cell is empty, it'll display "Incomplete" instead of "No Go".
Any ideas?
![]()
=IF(AND(B5>=TODAY();C5>=TODAY();D5>=TODAY();E5>=TODAY();F5>=TODAY());"GO";"NO GO")
Bookmarks