Or
=1+(RAND()0.5)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jean-Paul De Winter" wrote in message
...
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