Use Countblank(). This counts number of blanks in the range.
Also, not sure why you have all those ISNUMBER(MATCH(... functions...not needed here.
![]()
=IF(COUNTBLANK(F16:N16)>0,"Input Req'd",IF(E16=0,"",IF(O16="overdue","Overdue",IF(O16="Today","Today",IF(O16="Tomorrow","Tomorrow","ok")))))
Bookmarks