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

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
 
T

Tom-S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How To Have A Cell Be Blank If... 2
Conditional Formatting Minimim Value 2
How to determine the value within specific cell position? 5
Too many levels in the IF function? 12
Find the first & subsequent cells to contain text in a column & re 28
After Macro runs, no cell activated - what am I missing? 2

Top