Translations:Documentation/Calc Functions/RANDBETWEEN.NV/19/en
Formula | Description | Returns |
---|---|---|
=RANDBETWEEN.NV(20;30) | a non-volatile random integer between 20 and 30 | 23 |
=RANDBETWEEN.NV(A1;30) where A1 has 5 | a non-volatile integer between the value of cell A1 and 30. The function is recalculated when the contents of cell A1 change | 7 |
=RANDBETWEEN.NV(20.4;30.8) | a non-volatile random integer between 20 and 31, rounding to closest integers | 27 |