random# btw 1-9 without 6
 

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?

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)



In article ,
"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?

Hi Tracker
Maybe you could also consider this option.
=IF(RANDBETWEEN(1,9)=6,"",RANDBETWEEN(1,9))

HTH
Michael Mitchelson


"JE McGimpsey" wrote:

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)



In article ,
"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?

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?

Hey Ron
That's cool, and I thought I was thinking outside the square !!
--
Michael Mitchelson


"Ron Coderre" wrote:

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?

both of your answers were very helpful.If only i could think like that.Thankyou

"Michael" wrote:

Hi Tracker
Maybe you could also consider this option.
=IF(RANDBETWEEN(1,9)=6,"",RANDBETWEEN(1,9))

HTH
Michael Mitchelson


"JE McGimpsey" wrote:

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)



In article ,
"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?

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