.

RAND Function Dictionary

Function Dictionary Function Examples Function Categories

RAND            
 
Random greater than or equal to 0 but less than 1.
0.411529991  =RAND()
Random greater than or equal to 0 but less than 10
1.865846144  =RAND()*10
Random between 5 and 10.    
7.918311445  =RAND()*(10-5)+5
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.
Examples            
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 button
the 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.656259 29 0.059849853
Clubs 6 0.498168 34 0.456037825
Diamond 9 0.959762 30 0.905990234
Spades 13 0.427838 41 0.017371589
Clubs 9 0.457875 40 0.098525399
Diamond 7 0.042225 37 0.472090971
Diamond 4 0.957151 26 0.14943717
Clubs 10 0.573723 32 0.164031173
Spades 3 0.701588 21 0.631019456
Hearts 6 0.037028 19 0.726586375
Hearts 4 0.739884 7 0.867079111
Diamond 8 0.770855 10 0.136321667
Hearts 11 0.925667 16 0.307158646
Clubs 3 0.545986 8 0.450870615
Clubs 13 0.499758 48 0.639400017
Spades 5 0.233701 43 0.587246378
Diamond 3 0.339337 44 0.49523112
Spades 2 0.23019 4 0.001904043
Diamond 6 0.958178 3 0.43454957
Clubs 5 0.607992 45 0.945294671
Spades 1 0.052903 47 0.488904224
Clubs 12 0.652703 49 0.843792607
Hearts 10 0.049037 35 0.337142052
Hearts 13 0.514526 27 0.685550772
Spades 7 0.965358 1 0.199876089
Spades 6 0.672295 13 0.084354208
Diamond 12 0.765848 31 0.203684422
Hearts 3 0.911107 5 0.572448216
Hearts 5 0.470443 18 0.177621203
Hearts 8 0.578096 39 0.32496487
Hearts 1 0.448174 23 0.69853177
Diamond 13 0.977099 12 0.788249292
Hearts 9 0.326063 11 0.157748881
Clubs 4 0.766831 20 0.135064126
Diamond 5 0.000751 33 0.383104884
Spades 4 0.479062 42 0.671840955
Clubs 1 0.88559 24 0.452167293
Spades 8 0.755535 2 0.494827587
Hearts 7 0.837779 14 0.556944304
Diamond 1 0.361844 25 0.720770245
Clubs 2 0.632076 9 0.783328326
Hearts 2 0.22506 38 0.093812843
Diamond 11 0.630514 15 0.409500471
Clubs 7 0.430667 28 0.400416562
Spades 12 0.45734 17 0.428923041
Spades 10 0.623188 6 0.454207518
Clubs 11 0.303022 22 0.550766412
Diamond 2 0.185887 46 0.81918866
Diamond 10 0.342818 36 0.339801151
Spades 9 0.334081
Spades 11 0.128371
Hearts 12 0.673004

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download