Hi,

Depending on the values in column U, I want column V to have a value.
I am using an IF formula for this.
There is one problem. Some cells in Column U (eg U26) are blank(have
no values). However if I user U26 ="" for testing the condition, this
is resulting in FALSE. If I use =ISTEXT(U26), this is resulting in
TRUE. Similarly, ISBLANK(U26) is returning FALSE. There is no formula
in the cell. The column (U) is formatted as General. However, when I
press "Delete" in U26, ISBLANK returns TRUE and ISTEXT returns
FALSE. What could be wrong and how can I handle this?
One solution is to "Delete" the contents of the Blank cells. This is a
bit cumbersome as such blank cells are scatterred across the column. I
am posting this as the knowing the cause of the problem and the
solution would help me on future occasions also.

Thanks in advance for all the help.

Regards,
Raj