Forum Discussion
ISTEXT Function detecting empty spaces as text?
Hello, I have three cells; and two of these are dependent on the antecedent cell to work.
This is an example below - the actual function is more complicated but the error is no different.
We have three cells here; the first cell contains the ordinary text 'HELLO' on cell F103. The second cell G103, contains the formula =IF(ISTEXT(F103),"HEY", ""), which means that if F103 contains any text, it will display 'HEY', otherwise BLANK. So far so good. We then have cell H103, which functions in the exact same way, =IF(ISTEXT(G103),"HEY NOW", ""), if H103 contains any text, it will display HEY NOW, otherwise, Blank. Now here is the problem.
As you can see, despite the fact that reference cell G103 is blank, because F103 is blank, H103 is not blank. It becomes blank if I delete the formula from G103, or if I change G103 to a number, but not if it's changed dependent on F103.
Why is this the case, and how to correct for this?
Cheers 🙂
(you might see some smaller columns there, ignore, as it doesn't influence anything -- my format is slightly different every so often)
Anything between double quotes is text. And ISTEXT() detects correctly.
You may check instead for the length of G103 or for G103<>"".
1 Reply
- Detlef_LewinSilver Contributor
Anything between double quotes is text. And ISTEXT() detects correctly.
You may check instead for the length of G103 or for G103<>"".