Thread: Check data range and return false value if a cell is blank
View Single Post
  #2  
Old June 1st, 2010, 08:42 PM posted to microsoft.public.excel.misc
Bob Phillips[_3_]
external usenet poster
  
Posts: 489
Default 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