| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Need help with Formula. Need it to return Null, not Blank
I have the following formula which returns a blank text string rather than, specifically, nothing.
=IF(ISBLANK(DD28),"",DD28) This affects the text in the surrounding cells which don't overlap if there is an empty text string in the cell(s) next to it. So basically, it has to return an empty cell rather than a cell which just looks empty. I can't expand the cells as the table is being used directly into a web page. Any help would be greatly appreciated. Even if it's just getting the cell's text to be 'shown on top' or something similar. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return a blank formula cell if the reference is blank? | Excel Worksheet Functions | |||
| Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| COUNTIF says Null = Blank but Blank < Null | Excel Worksheet Functions | |||
| Can a function return a Null (blank ) value? Maybe a custom functi | Excel Worksheet Functions | |||
Threaded Mode
