Generate a random range of numbers in excel

Question

I'm looking for an excel formula to generate a random range of numbers between -0.3 and +0.3. These numbers can be at most 2 decimal places.

E.g here is a list of numbers I would expect this formula to return:

-0.24, 0.02, 0.13, -0.14, 0.3, 0.22, -0.29

and so on...

Many thanks

doerig · Accepted Answer · 2016-08-18 08:08:17Z

2

thats quite easy to do:

=RANDBETWEEN(-30;30)/100

answered Aug 18, 2016 at 8:08

doerig

1,8671 gold badge19 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks Doerig. Tried up voting you but says it's not displayed as my reputation is less than 15