View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert Blass Robert Blass is offline
external usenet poster
 
Posts: 35
Default =INT(0+(1-0+1)*RAND()) wtf?

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