JohnnyTightlips
Board Regular
- Joined
- Aug 13, 2006
- Messages
- 94
Folks,
A recent post talked about treating a cell as blank (i.e. not 0) from a graph point of view. It got me to thinking whether you can have Excel treat a cell containing a formula as blank. Typically I use "" to make it appear blank, but Excel doesn't treat it as such. i.e. =isblank(cell) would return FALSE.
Does such a formula/method exist?
A recent post talked about treating a cell as blank (i.e. not 0) from a graph point of view. It got me to thinking whether you can have Excel treat a cell containing a formula as blank. Typically I use "" to make it appear blank, but Excel doesn't treat it as such. i.e. =isblank(cell) would return FALSE.
Does such a formula/method exist?