creating addition/subtraction wksht

**lemoineer** · 04-21-2009, 02:56 PM

I'm a technology facilitator in an elementary school, and have created addition "worksheet generators" for my teachers in the past using the RANDBETWEEN function. I'm now trying to create a worksheet that prints as a single page that has addition and subtraction problems using numbers 0-10. I want to randomize whether each problem is addition or subtraction; and randomize so the numbers are from 1-10. I understand how to do this with an addition problem, since it doesn't matter if the first number is smaller than the second number. However, I'm not sure how to use Excel functions to create subtraction problems to make sure the second number is always less than the first number while allowing the numbers 1-10, and how to randomize whether the operator sign is addition or subtraction. Each number and the operator sign (the addition or subtraction sign) are in individual cells. Thanks for any help!

**Special-K** · 04-21-2009, 03:27 PM

Addition or subtraction would be a random INT(RAND()*2)+1 and maybe a CHOOSE to decide which operator the cell should be + or -

First number should always be GREATER than second and within range 1 to 10.
You mention numbers 0-10 first then change it to 1-10 in your description. Need to clarify which you want. Taken literally you mean second number should be GREATER than and NOT equal to first.

First number should be INT(RAND()*9)+2
Second should be INT(RAND*()*(9-"first"))+"first"

**lemoineer** · 04-21-2009, 05:26 PM

Thanks so much for the speedy response. Sorry about the confusion....I want 0-10. I used the functions you gave, but the second function sometimes returns a number over 10, and sometimes the second number is greater than the first number. I've attached a spreadsheet with my sample using your functions. Thanks for any add'l help you can provide!