ISTEXT returns TRUE if the cell contents refer to text. If an error occurs, the function returns a logical or numeric value.
ISTEXT(value)
value is a value, number, Boolean value, or an error value to be tested.
=ISTEXT(D9) returns TRUE.
=ISTEXT(C3) returns FALSE.