Random

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a sheet that will randomly display numbers for mathematical Addition or subtraction. How would I go about doing this? RAND doesn't work for me.
 
That's a very general question. A little more detail would help!

--

Vasant

Troy said:
I would like to create a sheet that will randomly display numbers for
Click to expand...
mathematical Addition or subtraction. How would I go about doing this? RAND
doesn't work for me.
 
I would like Cell "C3" and "C4" to generate any number from 1 to 10 so Cell "C3" could be added to Cell "C4". This is for my daughter's arithmetic class. It would be nice if everytime it was saved the cells would generate different numbers so she could be fast at arithmetic at any early age.
 
In both C3 and C4, put the formula:

=INT(RAND()*10)+1

Hitting the F9 key will give you a new pair of numbers.

--

Vasant



Troy said:
I would like Cell "C3" and "C4" to generate any number from 1 to 10 so
Click to expand...
Cell "C3" could be added to Cell "C4". This is for my daughter's arithmetic
class. It would be nice if everytime it was saved the cells would generate
different numbers so she could be fast at arithmetic at any early age.
 
Back
Top