Check data range and return false value if a cell is blank

  • Thread starter Thread starter DavidS
  • Start date Start date
D

DavidS

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
 
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
 
Back
Top