if greater then put a "1"

  1. S

    How "if great then 0 put a 1 in feild"

    In cell A I have number that is normaly -.50 to positive .50 and inbetween. In cell B1 I want to put a formula that says if the value in A1 is greater then 0 then put 1 in this cell. Can anyone help me on how to do a formula for this. thanks in advance.

Some videos you may like

This Week's Hot Topics