Random value with 2 or 3 decimal places
anakin_74
Posted messages
43
Status
Member
-
anakin_74 Posted messages 43 Status Member -
anakin_74 Posted messages 43 Status Member -
```html
I need to create a cell in a table containing a random value.
I want this value to be greater than the value in cell G4 and less than the value in cell G3.
I know the RANDBETWEEN function (sorry it's in English because I work in this language at the office), but it gives integer numbers.
I need numbers with 2 or 3 decimal places
Example: I have a LI (in G4) = 0.951 and LS (in G3) = 1.034, so in my case, I want a number like 1.012 or 0.999
I hope I have been clear enough. Thank you in advance.
2 answers
Hello
in French in the text:
=ROUND(RAND()*1000;3)
for a number from 0 to 1000 with three decimal places
(multiply by whatever you want to get the type of integer number you want, but the larger it is, the less likely you are to have redundancies)
or simply
=ROUND(RAND();3) for three decimal places after the 0
best regards
--
To err is human, to persist is diabolical
in French in the text:
=ROUND(RAND()*1000;3)
for a number from 0 to 1000 with three decimal places
(multiply by whatever you want to get the type of integer number you want, but the larger it is, the less likely you are to have redundancies)
or simply
=ROUND(RAND();3) for three decimal places after the 0
best regards
--
To err is human, to persist is diabolical
