RANDBETWEEN

Posted on 18-01-2020 , by: admin , in , 0 Comments

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.

Low High Random
5 10 6  =RANDBETWEEN(C4,D4)
1 49 26  =RANDBETWEEN(C5,D5)

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.

Lottery Numbers The Winning
Ticket!
1 49 40  =RANDBETWEEN ($C$24,$D$24)
34  =RANDBETWEEN ($C$24,$D$24)
Press function Key 49  =RANDBETWEEN ($C$24,$D$24)
F9 to recalculate. 35  =RANDBETWEEN ($C$24,$D$24)
8  =RANDBETWEEN ($C$24,$D$24)
8  =RANDBETWEEN ($C$24,$D$24)
32  =RANDBETWEEN ($C$24,$D$24)

Duplicates! Spin again

{=IF(SUM(1/COUNTIF(E24:E30,E24:E30))<>7,”Duplicates! Spin again”,”All OK”)} This formula is used to determine whether all the numbers are different. It is entered as an array using Ctrl+Shift+Enter.

Leave a comment