Try yhis formula in cell S1:

=IF(COUNTBLANK(A1:R1)0,"Incomplete","Complete")

Note that this will only check for blank cells - it won't check whether the
cell contents are valid data for your purposes.

Regards,

Tom


"DavidS" wrote:

Example
Check row A1:R1 and if at least one cell is empty then S1 should indicate
"incomplete" otherwise "complete" if every cell in the row has a value