Excel Tutorial – RANDBETWEEN

The RANDBETWEEN function in Microsoft Excel is a function that generates a random integer between two specified values. This function is useful for generating random numbers for various purposes, such as creating random samples, simulating data, and more.

To use the RANDBETWEEN function, follow these steps:

  1. Open Microsoft Excel and select the cell where you want the random number to appear.
  2. Type the following formula into the cell: =RANDBETWEEN(bottom, top)
  3. Replace “bottom” with the minimum value that you want the random number to be.
  4. Replace “top” with the maximum value that you want the random number to be.
  5. Press Enter to see the result.

The RANDBETWEEN function generates a new random number every time the sheet is recalculated. To force the sheet to recalculate, you can press F9 or click the “Calculate Now” button on the “Formulas” tab in the ribbon.

The RANDBETWEEN function is a very useful tool for generating random numbers within a specific range in Excel. You can use it to create random samples, simulate data, and more.

 

Leave a Reply