random numbers between 500 to 750 in multiples of 5

[apgmin]

Hello,

Can you give me the formula to generate a random number between 500 to 750 but should be in multiples of 5 ( like 505 or 620 or 655 etc)

 

[Misca]

Try =RANDBETWEEN(100,150)*5

 

[apgmin]

works perfectly thanks

 

[djo5003]

Place list of desired numbers in column. You can do this by typing in the first two numbers in successive cells then dragging the cells down until the desired number. For example type 500 in B1 and 505 in B2 then highlight both cells and place your mouse cursor over the bottom right corner of cell B2 and drag down. This will give you a list of the numbers.

Now in another cell you can use the following formula:

=INDEX($B$1:$B$51,RANDBETWEEN(1,COUNT($B$1:$B$51)),1)