Rand with decimals (positive value + negative value)

[ankitanks]

Hi guys,

I am tryin really hard to find a solution to this but no luck so far. I need two sets of random values.

1. Between 1 & 4. With one decimal
2. Between -17 & -20. With one decimal

Can you please help me achieve this?

Thank you heaps.

 

[Fluff]

Hi & welcome to MrExcel

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[ankitanks]

It is Microsoft 365.

 

[Fluff]

Thanks for that, how about

+Fluff 1.xlsm
	A
1
2	2.5
3	-19.4
Main

Cell Formulas
Range	Formula
A2	A2	=RANDBETWEEN(10,40)/10
A3	A3	=RANDBETWEEN(-200,-170)/10

And format the cell for 1 decimal

 

[ankitanks]

Thank you. That worked like a treat. Can you please explain the logic behind (10,40) & (-200, -170).

 

[Fluff]

By using 10 & 40 & then dividing by 10 you get a number between 1 & 4 with one decimal place.