Learn RandBetween Formula for produces a random whole number between two specified numbers.
Thursday, August 4, 2022

Learn RandBetween Formula for produces a random whole number between two specified numbers.

RANDBETWEEN

Learn Excel formula RandBetween

What Does It Do ?

This function produces a random whole number between two specified numbers.
The random number will change each time the spreadsheet is recalculated or F9 is pressed.

Syntax
=RANDOMBETWEEN(LowLimit,HighLimit)

Formatting
No special formatting is needed.

Example
The following table shows how the =RANDBETWEEN() has been used to generate six
numbers to use for the National Lottery.
Note that the function does not check to ensure all numbers are unique, the same number
could be generated twice or more.
Randbetween Excel formula Example-1

No comments:

Post a Comment

Youtube Channel Image
Accountax Solutions Subscribe To watch more Tutorials
Subscribe