Solved: Generating a 1 or 0 randomly with frequency l

[Tuneman12]

I want to have excel create a random variable, where it equals 1 x% of the time, and 0 (1-X)% of the time. Is there a simple way to do this?

Thanks again in advance.

[mdmackillop]

This should give you a 60/40 split. Adjust to suit
=IF(RAND()>0.6,1,0)

[Tuneman12]

Thanks a ton man!