Formula Help

  • Thread starter Thread starter SFrick
  • Start date Start date
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
 
...
...
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) .
 
Back
Top