@randbetween(1,100)

what?

That would be the Microsoft Excel cell formula to generate a random number between 1 and 100. You know, like when you have a drawing and need to pick a random number for a winner? Like I do here at Pragmatic Compendium every week? (it doesn’t have to be between 1 and 100. the number “100” can be replaced by any number)

I’ve posted detailed instructions and a screen shot for this little time saver over at the Pragmatic Computing blog, so if you are tired of drawing little pieces of paper out of a hat every time you want to “select a winner,” head on over and check it out!

Of course, don’t forget to enter this week’s clean sweep(stakes) giveaway while you’re here!

Find more great time and money savers at Works for Me Wednesdays at Rocks in My Dryer!

3 thoughts on “@randbetween(1,100)

  1. That’s a pretty neat formula. I don’t do drawings on my blog, just in real life. I use random.org to pick my #s but this would be great for the event I’m doing in a few weeks where we won’t have internet access!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.