Help with what should be a simple formula

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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
news:[email protected]...
>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.

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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
news:[email protected]...
>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.