G
Guest
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?
but excluding 6 as a posibility. is it possible?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
Assuming this is a different question than your other thread (please
keep questions in the same thread if possible - it reduces the chance
that people will waste time suggesting answers that have already been
offered), here's one way, using 2 cells (it's actually the same way, of
course):
A1: =RANDBETWEEN(1,8)
A2: =A1+(A1>=6)
keep questions in the same thread if possible - it reduces the chance
that people will waste time suggesting answers that have already been
offered), here's one way, using 2 cells (it's actually the same way, of
course):
A1: =RANDBETWEEN(1,8)
A2: =A1+(A1>=6)
G
Guest
Hi Tracker
Maybe you could also consider this option.
=IF(RANDBETWEEN(1,9)=6,"",RANDBETWEEN(1,9))
HTH
Michael Mitchelson
Maybe you could also consider this option.
=IF(RANDBETWEEN(1,9)=6,"",RANDBETWEEN(1,9))
HTH
Michael Mitchelson
G
Guest
Try this:
=CHOOSE(RANDBETWEEN(1,8),1,2,3,4,5,7,8,9)
Does that help?
=CHOOSE(RANDBETWEEN(1,8),1,2,3,4,5,7,8,9)
Does that help?
G
Guest
Hey Ron
That's cool, and I thought I was thinking outside the square !!
That's cool, and I thought I was thinking outside the square !!
G
Guest
both of your answers were very helpful.If only i could think like that.Thankyou
J
JE McGimpsey
Unfortunately, that won't work. The second RANDBETWEEN is independent of
the first, so if the first one<>6, the second one *could* =6.
the first, so if the first one<>6, the second one *could* =6.