RANDBETWEEN Function


In this topic we will look at the RANDBETWEEN Function.  

 

The RANDBETWEEN function lets you determine the start and end points for the random number to be generated

 


Steps:

  1. Select the cell where the information will be entered.

     

    Step 1
  2. Click the Formulas tab.

    Step 2
  3. Click Math & Trig 

    Step 3
  4. Click RANDBETWEEN.

    Step 4
  5. Click in the Bottom field.

    Step 5
  6. Enter your Bottom number.  In this example, enter 2.

    Step 6
  7. Click in the Top field.

    Step 7
  8. Enter your Top number.   In this example, enter 100.

    Step 8
  9. Click the OK button.

    Step 9
  10. The RANDBETWEEN function returned the number 58.

    Step 10

After completing this topic, you are familiar with the RANDBETWEEN Function.