| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Well, how empty is it?
Is it possible, without VBA, to test the emptiness of a cell? For example,
a formula that will return 1 if a cell is unused (has nothing in it), 2 if the cell has a formula returning a null string: =IF(1=1,,) 3 if the cell has a single quote in it and 4 otherwise? -- Gary''s Student - gsnu2007xx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clipboard empty but get cannot empty CB when trying to copy | Excel Worksheet Functions | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| in excel..:can't empty clip are" but already empty | Excel Discussion (Misc queries) | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
Threaded Mode
