Formula Help

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

"SFrick" wrote...
...
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) .

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.