top of page

Did you know Excel can generate random numbers?


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