Hi, I need produce numbers from 2 to 10, but avoiding the factors of another random number. So my first randbetween(2,10) produces 3, then my next randbetween(2,10) produces 9, which isnt suitable. I need either 4,5,7,8,10. And a similar case with 2, I need to produce either 3,5,7,9. Is there a way to omit some numbers?
Thanks
Last edited by Geomarsh; 08-05-2009 at 07:36 AM.
unless someone comes up with a better way a1=randbetween(2,3) just to generate those 2 numbers b2 contains the result
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There is probablya better solution to this but maybe this will work:
A1: =RANDBETWEEN(1,10)
B1: =RANDBETWEEN(1,10)
C1: =IF(AND(ISEVEN(A1),ISODD(B1)),A1,0)
D1: =IF(AND(ISEVEN(A1),ISODD(B1)),B1,0)
Hi, I dont really understand how martindwilson's verision works, as i need to produce about 800 examples so cant see it working as a long column unless im being really blind?
Second one works well, but if the if statements are false it just shows 0, which i cant use. what i want to do is produce a loop i think, so i want it to try a random number and then change it if it has a common factor or is a multiple of the first number iv produce. (I may have forgotten to add about the common factor into my orginal post!) As i am basically constructing a (proper) fraction that cant be simplified any farther.
eg I am producing denominator first, so say it comes out as 10, i cant have 2,4,5,6,8
If denom was 4, I cant have 2 as numerator.
ok try version 2
Choose a random row from this table:
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Hi thansk veru much MartinDwilson, version 2 works brilliantly, saved me alot of time!
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks