|=ISTEXT Returns TRUE|
"=IF(ISBLANK(Data!CA292),"ISBLANK") RETURNS FALSE
If I delete the contents of CA292 which appear empty I get the opposite of above
This is how it is supposed to work:
ISTEXT will return TRUE if there is a Space Character in the cell, Excel treats a space as a valid character.
ISBLANK will return FALSE if there is a Space Character in the cell, because the cell is NOT blank, there is a space character in the cell.
When you DELETE the contents of the cell, then the opposite is now True.