RAND

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

RAND

What Does It Do?
This function creates a random number >=0 but <1.
The number will change each time the worksheet recalculates, or when F9 is pressed.

Syntax
=RAND()

Formatting
No special formatting is needed.

Random greater than or equal to 0 but less than 1.
0.556910022  =RAND()
Random greater than or equal to 0 but less than 10.
5.449554695  =RAND()*10
Random between 5 and 10.
5.90726586  =RAND()*(10-5)+5

Example:

The following examples show how the =RAND() function has been used to randomly sort list of information.


A list of cards has been entered in column C, and =RAND() in column D. By clicking inside the random numbers and then using Data, Sort or the Sort buttonthe cards will be shuffled.


The same technique has been used to generate a list of six winning lottery numbers.

Card Random Lottery Random
Clubs 8 0.70937 29 0.333267746
Clubs 6 0.64028 34 0.55535302
Diamond 9 0.82884 30 0.626895556
Spades 13 0.40911 41 0.886633083
Clubs 9 0.30076 40 0.624961289
Diamond 7 0.86538 37 0.634377453
Diamond 4 0.61923 26 0.166082942
Clubs 10 0.76469 32 0.475269416
Spades 3 0.51927 21 0.147765887
Hearts 6 0.93713 19 0.553693125
Hearts 4 0.59568 7 0.403497179
Diamond 8 0.4573 10 0.522104725
Hearts 11 0.18812 16 0.457846259
Clubs 3 0.29231 8 0.217580443
Clubs 13 0.11548 48 0.442283773
Spades 5 0.88058 43 0.185719167
Diamond 3 0.54331 44 0.028993
Spades 2 0.32842 4 0.398961669
Diamond 6 0.366 3 0.251119209
Clubs 5 0.45062 45 0.041993056
Spades 1 0.74288 47 0.979361027
Clubs 12 0.21185 49 0.156508997
Hearts 10 0.71431 35 0.210071609
Hearts 13 0.54189 27 0.964704542
Spades 7 0.42839 1 0.826629451
Spades 6 0.05174 13 0.600607356
Diamond 12 0.38008 31 0.19678082
Hearts 3 0.42339 5 0.324459787
Hearts 5 0.46911 18 0.516573208
Hearts 8 0.1413 39 0.833408989
Hearts 1 0.66706 23 0.832560674
Diamond 13 0.91756 12 0.771446916
Hearts 9 0.61752 11 0.61612564
Clubs 4 0.50897 20 0.724047017
Diamond 5 0.78468 33 0.71568198
Spades 4 0.76871 42 0.323963117
Clubs 1 0.85245 24 0.196100607
Spades 8 0.75612 2 0.838187446
Hearts 7 0.88956 14 0.092310925
Diamond 1 0.76458 25 0.436693727
Clubs 2 0.42135 9 0.725186947
Hearts 2 0.07656 38 0.897467664
Diamond 11 0.43683 15 0.508245959
Clubs 7 0.83782 28 0.823989804
Spades 12 0.0467 17 0.106449153
Spades 10 0.56815 6 0.626420886
Clubs 11 0.52515 22 0.793481019
Diamond 2 0.27635 46 0.426226454
Diamond 10 0.21402 36 0.457713312
Spades 9 0.7237
Spades 11 0.77519
Hearts 12 0.00574

Leave a comment