Inserting "true" blanks with functions
Don't use ISBLANK() to test a cell. ISBLANK() will return FALSE unless the
cell is truely empty. Even a nuill character is not empty. For example, in
A1 enter:
=""
copy A1 and paste/special/value into A2
leave A3 truely empty
ISBLANK(A1) will return FALSE
ISBLANK(A2) will return FALSE
ISBLANK(A3) will return TRUE
--
Gary''s Student - gsnu200860
"bearspa" wrote:
I'm having a problem inserting a blank in a cell using a function so that
another formula that refers to this blank reads it as a blank.
For example, if A1 is a blank cell:
Formula Result
=ISBLANK(A1) TRUE
=IF(ISBLANK(A1)," ",1)
=ISBLANK(A3) FALSE
In the above example, even though =IF(ISBLANK(A1)," ",1) shows a blank cell
in A3, a reference to it in another formula shows that Excel does not think
it is blank.
How do you write a formula so that there is truly nothing in the cell as a
result?
|