View Single Post
  #7   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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))