I am trying to create exercise sheets for students to do division sums. Addition subtraction and multiplication was easy as I can just generate random numbers between 2 set values. With division however I need to generate a first number and then generate a second number that is a factor of the first so that the sum divides evenly without remainder. If anyone has any advice on how I can try and do this it would be greatly appreciated.
VBA coding is a better option. Is it ok.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Did not even know it existed until now, but if it will solve my problem I'm happy to give it a try.
If multiplacation was easy in that case division is also easy.multiplication was easy
You determine the two numbers in exactly the same way, but you show the product of these numbers and one of these numbers.
Is this information enough to adjust your own sheet? Otherwise, upload your sheet with the multiplication here.
Then we know exactly how you want it. Then a member can convert that to a division here.
You can generate the second number in B2:
=RANDBETWEEN(1,10)
And create the first number in A2:
=RANDBETWEEN(1,10)*B2
does this work
in A1 put - =B1*RANDBETWEEN(1,INT(1000/B1))
in B1 put - =RANDBETWEEN(1,500)
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
This is a really good example of trying to over complicate things, I tell students every day "Dont make it harder than it needs to be" yet multiply a random number by a random number never occurred to me... Thank you very much for all the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks