• Menu
  • Skip to right header navigation
  • Skip to main content
  • Skip to primary sidebar

Before Header

Call us TODAY for help!  (715) 572-5556

  • Facebook
  • LinkedIn

Exceling Your Business – Streamline Your Data

Back-office solutions using Excel

  • Blog
  • Products
    • From Shoebox to Toolbox ~ Expense Essentials
    • From Shoebox to Toolbox ~ Business Essentials
    • BOOK: Jumpstart Your Efficiency
    • Create Your E.X.C.E.L. System
  • Speaking
  • About Tina
    • How I Help
    • Testimonials
  • CONTACT US
  • Search
  • Blog
  • Products
    • From Shoebox to Toolbox ~ Expense Essentials
    • From Shoebox to Toolbox ~ Business Essentials
    • BOOK: Jumpstart Your Efficiency
    • Create Your E.X.C.E.L. System
  • Speaking
  • About Tina
    • How I Help
    • Testimonials
  • CONTACT US
  • Search

Mobile Menu

Create Random Numbers Quickly with Excel’s Random Number Generator

Have you ever needed to generate a bunch of random numbers and thought there must be a better way than pulling numbers out of a hat?

Well, there is! Excel can do it for you! Excel has two different options to use:

=RAND  –  Returns a random number greater than or equal to 0 and less than 1, evenly distributed and changes on recalculations. (This means every time you enter something in a cell and hit enter the values change.)

=RANDBETWEEN(1,100)  –  Returns a random number between the numbers you specify, also changes on recalculation. In this example, the numbers are between 1 and 100. (This means every time you enter something in a cell and hit enter the values change.)

What the “changes on recalculation” means is that whenever something is added to a cell or changed in a cell the formulas for both the RAND and RANDBETWEEN functions calculate new numbers.

Look at the above snapshot with the original calculations, now look below to where the numbers were copied and pasted, using the paste special value option, now look to the left in columns A & C to the original calculations, all the numbers changed when I pasted special in columns F & H.

What else can you do with this you ask? If the kids are bored and have no dice you can still play a dice game using the RANDBETWEEN function. Simply type in   =RANDBETWEEN(1,6)   and Excel will choose a number from 1 to 6.

Have fun and stay productive!

Category: Tips

Looking for immediate answers to your questions?

Schedule a no-cost consultation today!

Yes Tina, I’m ready to learn more about how I can better manage my business using Excel!

Previous Post: « Excel ‘FUN’damentals
Next Post: Excel Formulas Made Easy »

Copyright © 2023 Exceling Your Business · Designed by PodWorx, Inc. · Log in