| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Blank Cell in case of false If | Excel Worksheet Functions | |||
| Return value 1 row above non-blank cell in range | Excel Discussion (Misc queries) | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| IF function - need FALSE to return a blank cell, not 0 | Excel Worksheet Functions | |||
| Return True/False to check duplicate items in a range with one for | Excel Worksheet Functions | |||
Linear Mode
