Excel random numbers

• COUNT function
• BETWEEN function

When it comes to generating random numbers, Excel offers two useful features: RAND (SLCHIS) and RANDBETWEEN (IN BETWEEN).

SLCHIS

Function RAND (RAND) generates a random decimal number between 0 and 1.

1. Highlight a cell A1.
2. Enter the following formula and click Enter.

   =RAND()

   =СЛЧИС()

Function RAND (RAND) takes no arguments.

3. To create a list of random numbers, select a cell A1, hold its bottom right corner and drag it down.

   Note that the value in the cell A1 has changed. This happened because the random numbers change each time the program recalculates.

4. If you don’t want this, just copy the random numbers and paste them as values.
5. Select cell C1 and look at the formula bar. Now this cell contains a value, not a function RAND (SLCHIS).

BETWEEN THE CASE

Function RANDBETWEEN (RANDBETWEEN) returns a random integer between two boundaries.

1. Highlight a cell A1.
2. Enter the formula below and click Enter.

   =RANDBETWEEN(50,75)

   =СЛУЧМЕЖДУ(50;75)

   

If you want to generate a range of non-integer numbers between 50 and 75, use the following formula:

=50+25*RAND()

=50+25*СЛЧИС()