Try
=IF(AND(T(C4)<C4,C40),"yes","no")

the two conditions check that the cell has a value that is greater than
zero, and that the cell contents aren't text.... the T() function returns
the value of the cell only if the contents are text.

Cheers,

Glen