Random

[Troy]

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.

 

[Vasant Nanavati]

That's a very general question. A little more detail would help!

--

Vasant

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.

 

[Troy]

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.

 

[Vasant Nanavati]

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

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.