Formula Help

[SFrick]

In row 5 I have a formula that retuns: Text, negative numbers, and
positive numbers

In row 10 I want a formula that I can copy across and if the cell in
row 5 above is greter then or equal to 1, retuns a 1, if not returns
0.

I wrote this formula for cell g10: If(g5>=1,1,0) Simple enough
formula however in cell g5 is text and the formula still return 1 when
it should hve returned 0.

thanks for help

 

[Rick]

This may not be the easiest, but it's not very complicated
and I tested it it will work for what you need.

=IF(ISTEXT(G5),0,IF(G5>=1,1,0))