| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to get a function to return a null value that passes the ISBL.
"Hawk" wrote: How do I get a function to return a null value that passes the ISBLANK test? Using "" doesn't do it. What version are you using? Has anyone tried 2007 yet? I discovered the same prob w Excel 2000 today. I used the "cell" function which returned "l" for "label" instead of "b" for "blank." If I highlighted the cell and hit delete then it's officially "blank." I skimmed options but didn't see anything obvious. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| Have DGET return Null instead of #Value! | Excel Worksheet Functions | |||
| Can a function return a Null (blank ) value? Maybe a custom functi | Excel Worksheet Functions | |||
| Cell to return null instead of 0 | Excel Discussion (Misc queries) | |||
| return a " " for null values | Excel Worksheet Functions | |||
Threaded Mode
