ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need help with Formula. Need it to return Null, not Blank (https://www.excelbanter.com/excel-discussion-misc-queries/268404-need-help-formula-need-return-null-not-blank.html)

Aled Davies

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.


All times are GMT +1. The time now is 02:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com