I want a formula that randomly generates whole integers between -99 and +99. I want to make random exercises for my son, adding, subtracting, mult, dividing these numbers. I can't get past: cell A1 = INT (RAND()*100). This formula gives me ALL positive integers.
I am usually pretty good with EXCEL, so be as difficult as you like .
2007-01-03 00:56:56 · 4 answers · asked by Anonymous in Science & Mathematics ➔ Mathematics
STOPPP ANSWERING MY FRIENDS,
The first guy was correct, but I must wait 4 hours to select him for the 10 points. ALL 3 OF YOU WERE CORRECT...thanks.
2007-01-03 01:12:03 · update #1
I'm not sure of the exact Excel syntax, but I do know my math.
Try something like INT(RAND()*200 - 100. Wouldn't that do the trick?
2007-01-03 00:59:41 · answer #1 · answered by Bramblyspam 7 · 1⤊ 0⤋
a trick might work. Get a random number up to 200 and then subtract 100 from it.
2007-01-03 01:00:52 · answer #2 · answered by misiekram 3 · 0⤊ 0⤋
a million. Why now no longer located the IF test in the present day into mobile A7 rather of A1? e.g =IF(A2=a million,5,"") 2. If the 7 IF statements are too proscribing, verify out a analyze table with which you would be waiting to have a great volume of prerequisites based upon the size of the table.
2016-11-26 00:32:02 · answer #3 · answered by cantabrana 4 · 0⤊ 0⤋
Some choices are
INT(RAND()*200)-100
If( (RAND>=0.5,INT(RAND()*100),-(INT(rand()*100)))
The lower chooses if positive or negative then generates the number.
The first is quicker
2007-01-03 01:06:40 · answer #4 · answered by Selphie 3 · 1⤊ 0⤋