Formula Help

  • Thread starter Thread starter SFrick
  • Start date Start date
S

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
 
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))
 
Back
Top