Formula Watch: Picking random numbers in Excel

If you ever need a random number - say to pick a place for lunch, flip a coin, or select someone for a prize or work duty - you could just enter this handy little function into Excel:

=RANDBETWEEN(1,10)

The above function picks a number between 1 and 10, but you could select any numbers you want. For a virtual coin toss, you could use:

=RANDBETWEEN(1,2)

If you want to run it again to pick another number, select the cell, click inside the Insert Function box at the top of your worksheet, and hit Enter. Just be aware that doing so will cause any other random functions in that same sheet to run again as well.

Suzanne