View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
davids davids is offline
external usenet poster
 
Posts: 10
Default 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