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
- Click on an empty cell (like F5 )
2. Click on fx icon (or press shift+F3)
3. In the insert function tab you will see all functions
4. Select math and trig category
5. Select RANDBETWEEN function
6. Then select ok
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
Examples of RANDBETWEEN function in Excel
Example 1:
How to use RANDBETWEEN function in excel
You can see examples of RANDBETWEEN function below:
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 43What 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)
