Formula Help

S

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
 
H

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.
Click to expand...
...

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