How to Control the distribution of 0's and 1's using Rand function?

Hi,

This is my first forum post. When using the Rand function, it gives an even distribution between the two numbers 0 and 1. I would like to find out how I can control the distribution ratio of 1's to 0's. I do not want it to be an even (~50%) split between the two numbers.
For example, I would like to be able to set it to 75% of the random mix is 1's while 25% is 0's,
Or 60% of 1's and 40% of 0's, etc.....

I am using the following to create a 10 column grid of random 1's and 0's. However, I don't want a ~50% mix. How can I set my own adjustable distribution?

Please Login or Register  to view this content.

Thank you very much for any help you can provide.

There was a similar post a couple days ago here:

http://www.excelforum.com/excel-prog...html?p=2834079

My suggestion was to use a bit of code:

Please Login or Register  to view this content.

I'm not sure what you are doing with the last loop, deleting extra rows? You could use intRows from this version...

Thank you. This works perfectly.
Yeah that last loop was pretty useless. I took it out.