Hi

I need to create a long list of 0 and 1 randomly generated, but one number should have a slightly better chance of showing up, say like 0.5%.

I figured out the =RANDBETWEEN(0,1) but not how to give a better odd for one number.

Can it be done?

Thanks,

Leo.