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?
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 <[email protected]>,
"Tracker" <[email protected]> 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 <[email protected]>,
> "Tracker" <[email protected]> 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 <[email protected]>,
> > "Tracker" <[email protected]> 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 <[email protected]>,
"Michael" <[email protected]> wrote:
> =IF(RANDBETWEEN(1,9)=6,"",RANDBETWEEN(1,9))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks