# Different methods to generate Random Values in Excel

Following are 4 different methods to generate random numbers in Excel

## RAND Function

The RAND function in Excel can be used to generate a random number between 0 and 1.

The RAND function is a volatile function and will update every when the worksheet is recalculated.

## RANDBETWEEN Function

The RANDBETWEEN function returns a random number between two specified values in it.

For example, the formula =RANDBETWEEN(10,75) will return a random number between 10 and 75.

The RANDBETWEEN function also is a volatile function and will update every when the worksheet is recalculated.

## RANDARRAY Function

The RANDARRAY function is of the new Dynamic Array Function which can return an array of random numbers.

The RANDARRAY function accepts 5 arguments which can used to specify the number of Rows, Columns, Number limits and type of number, whether Integer or Decimal.

=RANDARRAY(9,5,-15,50,TRUE) will return an array of 45 Integers between -15 and 50.

For decimal numbers, use FALSE instead of TRUE.

### Excel Macro to generate random number

The following VBA code when executed will generate a random number between 50 and 999, in the cell C3

```Sub CreateRandomNumber()
Range("C3").Value = Int((999 - 50 + 1) * Rnd + 50)
End Sub```