Random number within a specified percent of another number

En4sir

New Member
Joined
Aug 13, 2012
Messages
6
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
Can anyone please help me with this?

1607690167970.png


Thanks
Mark
 

Some videos you may like

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

Toadstool

Well-known Member
Joined
Mar 5, 2018
Messages
1,395
Office Version
  1. 2016
Platform
  1. Windows
Solution

En4sir

New Member
Joined
Aug 13, 2012
Messages
6
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
 

Sulprobil

Board Regular
Joined
May 12, 2020
Messages
147
Last edited:

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top