View original (French)

Generate a random number between given decimal bounds

Solved
Bernard_35 Posted messages 2 Status Member -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Hello,

I know that several posts already address this question, but despite the numerous answers, I still can't achieve the desired result...

I would like to obtain random numbers between bounds where the numbers are less than 0 and have a decimal point.
For example, for my first line, I would like to generate a random number between 0.154 and 0.238.

Thank you very much for your help.

3 answers

Answer 1 / 3
Bernard_35 Posted messages 2 Status Member
 
Super, it works!! Thank you very much.
0
Answer 2 / 3
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
 
No worries
I’m marking the topic as resolved
safe travels
best regards

--
The quality of the response mainly depends on the clarity of the question, thank you!
0
Answer 3 / 3
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
 
Hello
for three decimal places according to your example:
=RAND.BETWEEN(158;234)/1000
thank you

--
The quality of the answer mainly depends on the clarity of the question, thank you!
-1