Formula Help

[SFrick]

In row 5 i have text, positve and negative numbers.

I need a formula that will return 1 when the cell above in row 5 is
positive and 0 when it is negative or text.

I tried if(m5>=1,1,0) but that still will return 1 in cells where
there is text.

Thanks for the help.

Frick

 

[Harlan Grove]

...
...

I need a formula that will return 1 when the cell above in row 5 is
positive and 0 when it is negative or text.

I tried if(m5>=1,1,0) but that still will return 1 in cells where
there is text.

...

Try =IF(N(M5)>0,1,0) .