If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
"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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating a check mark box | MarthaSue | Setting up and Configuration | 18 | April 28th, 2005 12:31 AM |
need help with a simple time formula | wize | Worksheet Functions | 2 | April 23rd, 2005 01:32 AM |
Simple Date Formula | FreddieTheFrog | General Discussion | 6 | June 24th, 2004 10:47 PM |
simple formula | Ash T. | General Discussion | 8 | June 12th, 2004 03:52 PM |
Simple formula nested in ISERR | P. Balmanno | Worksheet Functions | 1 | March 31st, 2004 02:09 AM |