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 | ||||||||