top of page
Search

Generate Random Numbers using RANDBETWEEN function

  • Ketul Patel
  • Jul 27, 2016
  • 1 min read

Formula Syntax

=RANDBETWEEN(Bottom, Top)

Bottom represents the lower value of the range, and

Top represents the upper value of the range

The formula will generate random numbers between bottom and top. For example, =RANDBETWEEN(1000,9999) might generate the number 1777.

This formula will calculate a new value each time the worksheet is calculated. Therefore, it is suggested to copy the values generated by the formula and paste them as values.

Example

 
 
 
Featured Posts
Recent Posts
bottom of page