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 -
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.
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
-
-
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! -
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!
