Are you looking for this?

=INT(2*RAND())

--
Rick (MVP - Excel)


"Robert Blass" wrote in message
...
=INT(0+(1-0+1)*RAND())

The "(1-0+1)" part makes no sense...

how can I express the random formula in shortest form?

=INT(0+(2)*RAND())???

I need a 1 or 0, no other options and fully whole numbers.

thanks a load.