Formula Help

S

SFrick

I have this formula in Row 10 that based on other cells returns;
negative number, Text, positive numbers.

I need a formula to add to row 5 that will return the number 1 if the
cell below in row 10 is greater then or equal to

For example; d10=C

In cell d5 i tried the formula if(d10>=1,1,0) the formula returned 1
when it should have returned 0

Thanks for all help.
 
Top