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

[SALO]

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.

 

[Blade Hunter]

=if(A1>0,1,"")

Will be 1 if A1 is greater than 0 or blank otherwise.

 

[SALO]

Thanks will try that

 

[mikerickson]

The SIGN function might help you.