Hi! I just registered here. Hopefully you guys might be able to help me with a problem

I would like to generate a random number (0 or 1) where the probability of getting a 1 is determined by another cell with a probability.

For example if the probability value in the cell is 0.75 then the random number would be 1 75% of the time and 0 25% of the time.

My plan is to have a long column (1000+ rows) with probablities and then generate the 0 or 1 in the next column for each probability.

Is this possible to do with formulas or do I have to involve VBA/macros?

Thank you!