Try this:

=CHOOSE(RANDBETWEEN(1,8),1,2,3,4,5,7,8,9)

Does that help?
--
Regards,
Ron


"Tracker" wrote:

im trying to use rand() or randbetween to get a random number btwn 1 and 9
but excluding 6 as a posibility. is it possible?