How do you make a simple math problem like 25÷5 in calc. I want to use random numbers for x (1, 100) and for y (1,10) so that the answer does not have decimals …
Thanks in advance
I think you need to start with a table of divisors such as that at Table of divisors - Wikipedia.
- Remove all the primes by filtering and deleting
- Delete all the columns except A & B
- Select the data in Column B and click Data > Text to columns. Make the Separator a comma, and tick the box Trim spaces. OK
- You now have a table that you can use as in spreadsheet below. Probably there is a way to randomly select the columns for the divisor but I didn’t find it. Copy and paste elsewhere as text
RandomDivision2.ods (21.2 KB)
Edit: Modified with random column selection on Hidden sheet and displayed in sheet Question2
=let(
y;randbetween.nv(1;10);
x;y*randbetween.nv(2;10);
x&" ÷ "&y&" = "& x/y
)
disclaimer: I wrote my answer without the help of a stupid AI prompt!
2 Likes
=LET(
y;RANDBETWEEN.NV(1;10);
x;y*RANDBETWEEN.NV(2;10);
x & CHOOSE(RANDBETWEEN(1;4);"+";"-";"×";"÷") & y & " = ")
disclaimer: I wrote my comment with @karolus help
2 Likes
Hi,
you could try this formula
=INT(RANDBETWEEN(1;100)/RANDBETWEEN(1;10))
NB: Sometimes you might get a zero as a result
Sorry, I’m not English native speaker.
- More interesting to us? Probably!
- More useful for a problem set? Not in every setting!
On some educational levels, the concept of “divide by one” is also important to convey. It is not intuitively grasped by every student.
Do you really want to keep posting screenshots of AI prompts, instead providing Answers by your own?
well,at some pt, soon, no one will ask here 
pasting the text doesn’t show up properly; need to check how gemini can share links.
hope you realize this ownership is a bit of a myth (and a lot of noise).
99% it’s just repeating what has been answered already,
with maybe 50% of just #More_details 
Ask your friend:
chicken&egg 
To link to “this discussion,” I need more information! Since I am an AI and don’t have a live “current discussion” in the way a human might, you’re likely referring to something specific.
Please tell me:
Where is this discussion taking place? (e.g., a specific website, forum, social media platform, internal communication tool, etc.)
Is there a specific post, comment, or thread you want to link to?
Once I have that information, I can tell you how to get the link
but doable : https://gemini.google.com/share/4a7606b63cff
Edit! My reply is essentially what AI said, above. I stand stricken ;-)
You want to have integer dividend <=100, integer divisor <=10 and integer quotient. The easiest way I see is to approach it a little backwards:
First generate the divisor. That will be a number between 1 and 10.
=RANDBETWEEN(1;10)
Then generate the quotient. That number must be 100/<divisor> or smaller.
=RANDBETWEEN(1;100/<divisor>)
The dividend will then be the product of divisor and quotient.
A one-liner for dividend, with the quotient as an intermediate result, is easy to make. With that, the chosen quotient does not need to be contained in a separate cell. See sample attached:
Integer_division_no_remainder.ods (12.8 KB)
1 Like
You could also start thinking for yourself instead of asking a new question for every possible arithmetic operation!
2 Likes
probably a bot