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.    W...