Excel RANDBETWEEN Function

What is RANDBETWEEN function in Excel?

The RANDBETWEEN function is one of the math functions of Excel.

It Returns a random number between the numbers you specify.

We can find this function in Math & trig category of insert function Tab.

How to use RANDBETWEEN function in excel

  1. Click on an empty cell (like F5 )
empty cell in excel

2. Click on fx icon (or press shift+F3)

 fx icon in excel

3. In the insert function tab you will see all functions

insert function tab in excel

4. Select math and trig category

5. Select RANDBETWEEN function

6. Then select ok

 excel RANDBETWEEN function

7. In the function arguments Tab you will see RANDBETWEEN function

8. Bottom section is the smallest integer RANDBETWEEN will return

9. Top section is the largest integer RANDBETWEEN will return

10. You will see results in the formula result section

How to use RANDBETWEEN function in excel

Examples of RANDBETWEEN function in Excel

Example 1:

How to use RANDBETWEEN function in excel

You can see examples of RANDBETWEEN function below:

Examples of RANDBETWEEN function in Excel
randbetween(A2,B2) ----->>>>answer is  3

randbetween(A3,B3) ----->>>>answer is  12

randbetween(A4,B4) ----->>>>answer is  24

randbetween(A5,B5) ----->>>>answer is  38

randbetween(A6,B6) ----->>>>answer is  43

What is the purpose of RANDBETWEEN function?

It Returns a random number between the numbers you specify.

What is the Return value of RANDBETWEEN function?

It returns a number.

How many arguments does RANDBETWEEN function have?

This function has just 1 Argument.

The argument of RANDBETWEEN function is number.

Bottom section is the smallest integer RANDBETWEEN will return.

Top section is the largest integer RANDBETWEEN will return.

The argument of RANDBETWEEN function is required and not optional.

RANDBETWEEN(number) = number

Which version of excel supports RANDBETWEEN function?

This function is available for all excel versions (2003-2019)

Errors in RANDBETWEEN function

RANDBETWEEN related functions :

Leave a Reply

Your email address will not be published. Required fields are marked *