Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
#7
|
|||
|
|||
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
How to keep random number from changing using RANDBETWEEN? | Excel Worksheet Functions | |||
Excel random number | Excel Discussion (Misc queries) | |||
Excel 2003 random number generator | Excel Discussion (Misc queries) | |||
Selecting at random with weighted probability | Excel Worksheet Functions |