One way:

=IF(RAND()<0.5025, 1, 0)

should give about 49.75% 0's, 50.25% 1's.

In article <leo31773.1v972b_1126541106.5514@excelforum-nospam.com>,
leo31773 <leo31773.1v972b_1126541106.5514@excelforum-nospam.com>
wrote:

> 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.