top of page
Search

Did you know Excel can generate random numbers?

  • Writer: Enya Low
    Enya Low
  • May 13, 2017
  • 1 min read

When coming up with these examples, instead of having to come up with random numbers myself I got Excel to do it!

Example

Mad Hatter Chocolatier sells its products to a number of stockists. Hence I need a list of numbers (quantity ordered) between 5 and 20.

Excel Formula: =RANDBETWEEN(bottom, top)

Formula Made Easy:

Formula Applied:

Tip

Note:

  • Random numbers image sourced from Atomic Object

 
 
 

Comments


bottom of page