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.