Thread
:
random# btw 1-9 without 6
View Single Post
#
7
JE McGimpsey
Posts: n/a
Unfortunately, that won't work. The second RANDBETWEEN is independent of
the first, so if the first one<6, the second one *could* =6.
In article ,
"Michael" wrote:
=IF(RANDBETWEEN(1,9)=6,"",RANDBETWEEN(1,9))
Reply With Quote