1 or 0 outcome based on probability?

[sashoy]

Hi
I have problem with using formula, so I think that you can help me.
so, I have created excel spreadsheet with 500 rows. In column A i have random Value of occurance on certain event (from 1% to 100%) Lets imagine that we have tennis match and the probability for player a to win is 29% (totally random). Now I want in column B based on possibility of occurance to give me result 1 (which will be win) or 0 (lost match).
I think that I was clear enough. If you have further questions please ask me.
Thanks for any help.

 

[Scott Huish]

and so will T. Valko's if you replace the 0.29 with your cell reference holding your percentage.

 

[sashoy]

Yes I exactly did so, and it worked for me.