Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Excel Miscalculates simple formula..Help!! | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |