| 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 |
| 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 | |||
Threaded Mode
