Predictably Random: Using RAND and RANDBETWEEN in Excel


Traffic lights, plane and train schedules, TV guides... Life's full of predictability and cycles.  Ever feel like shaking things up?  Ironically, our beloved spreadsheet tool famous for introducing the thinking world to structure gives us a way to break the mold: the RAND and RANDBETWEEN functions!

If you need any random number between 0 and 1, you'll want to use

=RAND()

If instead you want a random integer that falls between two numbers, you'll use something like

=RANDBETWEEN(1,10)

Be aware that these randoms aren't just random once... they re-randomize (?) the values every time the sheet recalculates (typically any time you change something).  So if you want to generate random numbers and then keep them static, copy the cells and then Paste As Values.

Need additional help with RAND, RANDBETWEEN, or other Excel formulas?  Reach out today via live chat, email, or phone and we'll get your issue solved in minutes!