Random Numbers Divisible By Random Numbers

[omagoodness]

I am trying to create math practice exercises for my granddaughter. I want to create 2 columns of random even numbers between 2 values. No problem, I can do that. My problem is that I want the random numbers in column B to evenly divide into the corresponding number in column A. I know how to use the MOD function to test the divisibility of the number but I cannot figure out the formula to change the random number if MOD =false. Is this even possible?

 

[Cubist]

It's easier to go backwards i.e.generate the Quotient and Dividend then multiply them to get the Dividend.

Book2
	A	B	C
1	Dividend	Divisor	Quotient
2	943	41	23
3	1216	32	38
4	6840	95	72
5	2484	46	54
6	7347	93	79
7	3588	52	69
8	1349	19	71
9	477	9	53
10	1552	16	97
11	160	10	16
Sheet5

Cell Formulas
Range	Formula
A2:A11	A2	=B2#*C2#
B2:C11	B2	=RANDARRAY(10,,1,100,1)
Dynamic array formulas.

 

[omagoodness]

It's easier to go backwards i.e.generate the Quotient and Dividend then multiply them to get the Dividend.

Book2
	A	B	C
1	Dividend	Divisor	Quotient
2	943	41	23
3	1216	32	38
4	6840	95	72
5	2484	46	54
6	7347	93	79
7	3588	52	69
8	1349	19	71
9	477	9	53
10	1552	16	97
11	160	10	16
Sheet5

Cell Formulas
Range	Formula
A2:A11	A2	=B2#*C2#
B2:C11	B2	=RANDARRAY(10,,1,100,1)
Dynamic array formulas.

I'm not sure I understand all this but I will give it a go and see what happens. Thanks.

 

[Cubist]

I'm not sure I understand all this but I will give it a go and see what happens.

I'm saying randomly generate col B and C then multiply them to get A.

 

[omagoodness]

I'm saying randomly generate col B and C then multiply them to get A.

Great, I got it now. I just need to determine that upper limit for B & C to keep the value of A less than 50. My granddaughter is just leaning division and only working with small numbers. I can do that by trial and error. Thanks again for your help.

 

[HighAndWilder]

Great, I got it now. I just need to determine that upper limit for B & C to keep the value of A less than 50. My granddaughter is just leaning division and only working with small numbers. I can do that by trial and error. Thanks again for your help.

Did you only want even numbers?

 

[omagoodness]

Did you only want even numbers?

Not necessarily, they just have to be evenly divisible. No fractions.

 

[Cubist]

I just need to determine that upper limit for B & C to keep the value of A less than 50

Keep column B upper limit to 10 and C to 5. Should guarantee less than 50.

 

[omagoodness]

Keep column B upper limit to 10 and C to 5. Should guarantee less than 50.

Perfect. Thanks you so much.

 

[Peter_SSs]

@omagoodness
In future please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.