# Random number generator between values

#### Taconumber

##### New Member
Hey guys,

I need a formula to generate random numbers, based off a existing figure and in between values.

For example, I have 10456.876, 10654.676… etc in column A. I need it to generate numbers +/- 0.020 based of the values in column A.

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
=A1 + RANDBETWEEN(-20, 20) / 1000

Not clear what limitation of +/-0.02, but try either below formula:

A1:A100 is working range.

for range: -0.02,-0.01,0,0.01,0.02

Code:
``=INDEX(A1:A100,RANDBETWEEN(1,COUNTA(A1:A100)))+INDEX({-2;-1;0;1;2},RANDBETWEEN(1,5))/100``

For range: -0.02 & 0.02 only

Code:
``=INDEX(A1:A100,RANDBETWEEN(1,COUNTA(A1:A100)))+INDEX({-2;2},RANDBETWEEN(1,2))/100``

Replies
2
Views
178
Replies
5
Views
412
Replies
3
Views
436
Replies
4
Views
363
Replies
2
Views
587

1,206,711
Messages
6,074,475
Members
446,071
Latest member
gaborfreeman

### 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