Isblank not working when formula is inputted - what instead of?

Hi,

i have formula like here:

Screenshot_25.png

and next in cell [E3] i have formula

Please Login or Register  to view this content.

which is not working. How can i handle this?
And how isblank is working?

What is blank and empty and null for Excel?

Thank you!
Best,
Jacek

Try testing if the cell contains "" rather than ISBLANK.

agree with above however, for info, you can use COUNTBLANK rather than ISBLANK, former will return a 1/0 (equiv. to TRUE/FALSE coerced {in native XL})

so why isblank was designed?

thank you!

and how to check if cell is empty and avoid white spaces?

Best,
Jacek

A Null string is not a Blank, it's a 0 LEN string, so you could easily argue that ISBLANK works correctly... COUNTBLANK effectively addresses the null string issue.

Re: white spaces etc... depends on what you mean, exactly... if pure space

Formula:

Please Login or Register  to view this content.

if you mean other ASCII codes you might need to use CLEAN in conjunction with a SUBSTITUTE (or two), and TRIM etc...

thank you Xlent,

i mean tab, space.
What i wnat to validate is to have "" (empty/null/blank) in cell.

Best,
Jacek

Hi Richard,

problem is already solved but we are discussing what is null blank and empty in Excel.

Best
Jacek

Thank you Richard,

technically is solved but still i do not understand what are differences between lsblank and countblanck and why null is sometimes like empty etc.

Best,
Jacek

Yes, it's not the best setup, however Colin Legg {who I would say is one of the most talented XL related people around} summarised it like this:

Originally Posted by Colin Legg

An empty cell can be defined as a cell that contains absolutely nothing: no constant, no formula and no prefix character.
A blank cell can be defined as a cell which may be empty, or may contain a prefix character or a null string (formula result or constant).

and, from a Worksheet Function perspective, ISBLANK tests the above "Empty" definition whereas COUNTBLANK tests "Blank".

o wow thank you,

great answer!
Jacek