Thread: help for RAND
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CaptainQuattro
 
Posts: n/a
Default help for RAND


jinvictor Wrote:
when i use RAND() to choose no between 1-15, every time i do it, no
changes, how to stop that happen?
Example: A1-1,A2-3,A3-12,but when i do A2, A1 change to different no.

and what can i do if i want to pick random no between 1-15 but i dont
want 8 to show up?

what can i do if i want a1-a140 showing random no between 1-15, but
every no show up equally?


To stop number in A1 from changing, enter formula, and press F9 before
pressing enter.

To elimate "8's": try formula

=IF(RAND()*(15-1)+1=8,RAND()*(7-1)+1,RAND()*(15-1)+1)

To produce same random number in a cells A1 TO A140 enter rand()...
formula in cell A1 and make formula in cells A2 to A140 = $A$1


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=539613