Random number generator between values

[Taconumber]

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.

 

[shg]

=A1 + RANDBETWEEN(-20, 20) / 1000

 

[bebo021999]

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

=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

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