Thread: RANDOM NUMBERS?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert Blass Robert Blass is offline
external usenet poster
 
Posts: 35
Default RANDOM NUMBERS?

OMG

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


But te (1-0+1) makes no sense...explains?

On Fri, 10 Oct 2008 22:43:11 -0400, Robert Blass
sayd the following:

Need to generate a random number of either 0 or 1 but completely
rounded, no decimal points just a whole number.


thanks