Help with what should be a simple formula
 

I have created some simple sheets that I can run and print to create sheets
for my daughter to practice her math. The addition and multiplication was
simple but I am struggling with the subtraction.

Basically I am choosing a random (whole) number between 1 and 100 for the
numerator, using ROUNDDOWN((RAND()*100), 0).

I have used round down because on a parallel sheet I have the same numbers
appear in the same places, and then answer calculated below it. That way she
can easily mark her work and without the round down some answers were
slightly off due to the decimal places.

I have been having problems creating the denominator because I do not want
the number to be larger than the numerator, as I do not want her into
negative numbers yet.

I was trying to use an if statement that will leave the number if it is less
than the numerator but to pick again if it is more. I was thinking this was
so simple but when I actually went to do it I ran into circular errors and
other problems.

I know it can be done without much trouble but I am having brain fade.

Any help is appreciated.

Bryan

Say your numerator comes on cell A1 using your rounddow... ...formula and
you wan the denominator to be always lower than A1 then
=randbetween(1,A1)
will generate numbers lower that numerator


"B Millar via OfficeKB.com" wrote in message
...
I have created some simple sheets that I can run and print to create sheets
for my daughter to practice her math. The addition and multiplication was
simple but I am struggling with the subtraction.

Basically I am choosing a random (whole) number between 1 and 100 for the
numerator, using ROUNDDOWN((RAND()*100), 0).

I have used round down because on a parallel sheet I have the same numbers
appear in the same places, and then answer calculated below it. That way
she
can easily mark her work and without the round down some answers were
slightly off due to the decimal places.

I have been having problems creating the denominator because I do not want
the number to be larger than the numerator, as I do not want her into
negative numbers yet.

I was trying to use an if statement that will leave the number if it is
less
than the numerator but to pick again if it is more. I was thinking this
was
so simple but when I actually went to do it I ran into circular errors and
other problems.

I know it can be done without much trouble but I am having brain fade.

Any help is appreciated.

Bryan

"B Millar via OfficeKB.com" wrote in message
...
I have created some simple sheets that I can run and print to create sheets
for my daughter to practice her math. The addition and multiplication was
simple but I am struggling with the subtraction.

Basically I am choosing a random (whole) number between 1 and 100 for the
numerator, using ROUNDDOWN((RAND()*100), 0).

I have used round down because on a parallel sheet I have the same numbers
appear in the same places, and then answer calculated below it. That way
she
can easily mark her work and without the round down some answers were
slightly off due to the decimal places.

I have been having problems creating the denominator because I do not want
the number to be larger than the numerator, as I do not want her into
negative numbers yet.

I was trying to use an if statement that will leave the number if it is
less
than the numerator but to pick again if it is more. I was thinking this
was
so simple but when I actually went to do it I ran into circular errors and
other problems.

I know it can be done without much trouble but I am having brain fade.

Any help is appreciated.

Bryan

Choose your "Denominator" (actually the "subtrahend") first, then
form the minuend:

Subtrahend: ROUNDDOWN((RAND()*100), 0)
Minuend: Subtrahend+ ROUNDDOWN((RAND()*(100 - Subtrahend)), 0)

(use appropriate cell references in place of "Subtrahend" and "Minuend")

Then Minuend - Subtrahend will be 0, and the numbers will be
between 0 and 100.