revanthof92
New Member
- Joined
- May 13, 2014
- Messages
- 3
Pls help me to generate 100 random numbers between 100 and 300 in some range of cells like A1:j10
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
randbetween
- Thread starter revanthof92
- Start date
BiocideJ
Well-known Member
- Joined
- Jan 23, 2012
- Messages
- 1,734
Just entering the formula
=RANDBETWEEN(100,300)
in all of the cells should do it. This seems relatively obvious given that your subject line states randbetween.
Every time the workbook recalculates the random numbers will change.
If you want to make them static, copy/paste values over themselves.
Alternatively, if you don't want to (can't) use RANDBETWEEN this formula should also do the same thing.
=INT(RAND()*201+100)
=RANDBETWEEN(100,300)
in all of the cells should do it. This seems relatively obvious given that your subject line states randbetween.
Every time the workbook recalculates the random numbers will change.
If you want to make them static, copy/paste values over themselves.
Alternatively, if you don't want to (can't) use RANDBETWEEN this formula should also do the same thing.
=INT(RAND()*201+100)
Last edited:
Upvote
0
Similar threads
- Question
- Solved
