# Random number within a specified percent of another number

#### En4sir

##### New Member
Good morning,

I am trying to generate random numbers but with a bit of a twist.

range A1 thru A10 had a set of numbers
I would like range B1 thru B10 to have random numbers, but to be within a specified percentage of the value in the A range.
And then the same for C1 thru C10.
The percentage would allow the number to be random in both directions .. plus or minus.

I have tried using the randbetween to get this to work, but I cant figure out how to get the plus or minus percent value

Thanks
Mark

### Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

#### En4sir

##### New Member
Hi Mark,

Not sure my O Level maths holds up but I think it's:

En4sir.xlsx
ABC
11.0121.00101.0790
23.6514.21003.6280
34.5264.50203.6920
4-2.589-2.8410-3.4060
53.1033.37403.3150
61.7921.54001.7600
72.1111.73301.8600
83.2343.40903.4180
9-1.133-1.0700-0.9610
10-0.879-0.7830-0.6750
11
12
13
1420%
Sheet1
Cell Formulas
RangeFormula
B1:C10B1=SIGN(A1)*((RANDBETWEEN(ABS(A1*1000)-((ABS(A1*1000)*\$A\$14)),ABS(A1*1000)+((ABS(A1*1000)*\$A\$14)))/1000))
This is excellent. Thank you so much for the quick response!
Exactly what I was looking for. Much appreciated.

Thanks,
Mark

Last edited:

#### En4sir

##### New Member
Thanks Sulprobil!

This is great. I appreciate your help !

Replies
2
Views
59
Replies
8
Views
192
Replies
5
Views
104
Replies
7
Views
93
Replies
11
Views
504

1,127,847
Messages
5,627,239
Members
416,232
Latest member
Ash1432

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