Excel RAND Function

What is RAND Function in Excel?

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

It Returns a random number greater than or equal to 0 and less than 1, evenly distributed (changes on recalculation).

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

How to use RAND 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 RAND function

6. Then select ok

excel RAND function

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

8. The Rand function has no arguments

9. You will see results in the formula result section

How to use RAND function in excel

Examples of RAND function in Excel

Example 1:

How to use RAND function in excel

You can see examples of RAND function below:

Examples of RAND function in Excel
rand(A2) ----->>>>answer is  0.840

rand(A3) ----->>>>answer is  0.297

rand(A4) ----->>>>answer is  0.078

rand(A5) ----->>>>answer is  0.351

rand(A6) ----->>>>answer is  0.147

What is the purpose of RAND function?

It Returns a random number greater than or equal to 0 and less than 1, evenly distributed (changes on recalculation).

What is the Return value of RAND function?

It returns a number.

How many arguments does RAND function have?

This function has no arguments.

The argument of RAND function is number.

The argument of RAND function is required and not optional.

RAND(number) = number

Which version of excel supports RAND function?

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

Errors in RAND function

RAND related functions :

Leave a Reply

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