=INT(0+(1-0+1)*RAND()) wtf?

[Robert Blass]

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

 

[Robert Blass]

Since it's impossible for a computer to make a random number then how
can we do this for real?

I only have a computer to use.

thanks

 

[Rick Rothstein]

Are you looking for this?

=INT(2*RAND())

 

[T. Valko]

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

how can I express the random formula in shortest form?

Try one of these:

This requires the Analysis ToolPak add-in be installed on versions of Excel
prior to Excel 2007.

=RANDBETWEEN(0,1)

Another way:

=ROUND(RAND(),0)

 

[Robert Blass]

by god that was it!