# Documentation/Calc Functions/RAND.NV

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

RAND.NV

## Category:

Mathematical

## Summary:

Generates a uniformly distributed random number in the range 0 (inclusive) to 1 (exclusive). In contrast to RAND, RAND.NV is a non-volatile function that is not recalculated at every input event.

## Syntax:

RAND.NV()

## Returns:

Returns a real number in the range [0, 1).

## Arguments:

None.

## Additional details:

- RAND.NV is a non-volatile function. Such functions are not recalculated at new input events and do not recalculate when selecting
*F9*, except when the cell containing the function is selected. Non-volatile functions are recalculated when opening the file. ▸ ▸ or pressing

- Use the RAND function for a volatile equivalent that satisfies ODF 1.2 and is compatible with Microsoft Excel.

- To generate random numbers that never recalculate, either:

- Copy cells containing
`=RAND.NV()`

, and use ▸ (with**All**and**Formulas**deselected and**Numbers**selected). - Use ▸ ▸ to fill a selected cell range with random numbers, generated in accordance with the flexible settings available through the Random Number Generator dialog.

- Copy cells containing

- To generate numbers in a range other than [0, 1), either:

- Scale the value returned by RAND.NV to a new range using a formula of the form
`=(RAND.NV()*(b-a))+a`

to generate a number in the range [a, b]. For example, the formula`=(RAND.NV()*20)-10`

would generate random numbers in the range [-10, 10). - Use the RANDBETWEEN function or its non-volatile equivalent RANDBETWEEN.NV.

- Scale the value returned by RAND.NV to a new range using a formula of the form

## Examples:

Formula | Description | Returns |
---|---|---|

=RAND.NV() | Generates a random number r in the range 0 ≤ r < 1. The resulting value will not change whenever Calc recalculates. |
0.80206289793007 |

## Related LibreOffice functions:

## ODF standard:

None.

## Equivalent Excel functions:

None.