Maybe an IF statement with if even number then recalc the random?

"leo31773" 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.
>
>
> --
> leo31773
> ------------------------------------------------------------------------
> leo31773's Profile: http://www.excelforum.com/member.php...o&userid=27179
> View this thread: http://www.excelforum.com/showthread...hreadid=466820
>
>