Learn How to Use Microsoft Excel RAND Function

Microsoft Excel RAND Function

The main function of the Microsoft Excel RAND function is to get the random number between 0 and 1. That implies, with the help of the RAND function you can able to return the random numbers between 0 and 1 as a result. Let's say for example, =RAND() will return a result in the form of a number like 0.422245717. The RAND function recalculates when a worksheet is opened or changed. So, with the help of the RAND function, you can able to get the random number between 0 and 1.

Return Value of RAND Function

The return value will be the number between 0 and 1.

Syntax of RAND Function

=RAND( )

How to Use Microsoft Excel RAND Function?

So we know that Microsoft Excel RAND function you can able to get the random number between 0 and 1. That implies, with the help of the RAND function you can able to return the random numbers between 0 and 1 as a result. Let's say for example, =RAND() will return a result in the form of a number like 0.422245717. The RAND function recalculates when a worksheet is opened or changed. So, with the help of the RAND function, you can able to get the random number between 0 and 1.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel