Thread: random number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jean-Paul De Winter Jean-Paul De Winter is offline
external usenet poster
 
Posts: 46
Default random number

Hi
I need a random number... or it is 1 or it is 2
Now I use this "formula"
score = Int(Right(Val(Second(Now()) * 3.14), 1))
If score = 6 Then score = 2 Else score = 1
it is placed in a loop but doesn't really returns 1 and 2 randomly

Any idea?
Thanks