Thread: Check data range and return false value if a cell is blank
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
  
Posts: 834
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


Reply With QuoteReply With Quote