# random numbers between 500 to 750 in multiples of 5

#### apgmin

##### Board Regular
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)

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Try =RANDBETWEEN(100,150)*5

works perfectly thanks

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)

Replies
3
Views
294
Replies
1
Views
85
Replies
0
Views
73
Replies
5
Views
191
Replies
3
Views
458

1,203,071
Messages
6,053,375
Members
444,658
Latest member
lhollingsworth

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back