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

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

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

=IF(COUNTA(A1:R1)=18,"Complete","Incomplete")

--

HTH

Bob

"DavidS" wrote in message
...
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

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

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