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