i want to generate 500 random numbers from 100 to 240

[SOURAV]

i want to generate 500 random numbers from 100 to 240 and then perform descriptive statistics on it

 

[Michael M]

Try

=RANDBETWEEN(100,240)

Drag down as far as required

 

[SOURAV]

That just gives me one random number

 

[pgc01]

That just gives me one random number

What do you mean?

It should be as many numbers as the cells that have the formula.

Do they all display the same number?

 

[pgc01]

... or do you have the Calculation in your workbook set to manual? In that case recalculate.