# An Overview of RAND Function | Microsoft Excel

The RAND function is one of the math and trigonometry functions in Microsoft Excel. It can be used as a standalone function as well as in collaboration with the other functions. This article will give you an overview of the RAND function in Excel.

Table of Contents

### Objectives

The RAND function generates a random positive number in the range 0 ≤ x < 1.

### Syntax

`=RAND()`

### Arguments

• It has no argument

### Output

A positive fraction number in the range 0 ≤ x < 1.

## Examples of RAND Function

Suppose, you want to generate some random fraction numbers greater than or equal to 0 and less than 1. You can simply use the RAND function to achieve this. Use this formula:

`=RAND()`

## Usage Guide of RAND Function

Step_1: Start with inserting an equal sign (=) in a blank cell.

Step_2: Then type RAND.

Step_3: After that, type a pair of open and close parenthesis “()”.

Step_4: Press ENTER.

The RAND function will return a random positive fraction number within 0 and 1.

Step_5: To generate more random numbers, click and hold the left mouse button. Then drag the Fill Handle down.

Final Result

Release the left mouse button now. It will get a plethora of random positive fraction numbers.

## Recalculate Random Numbers

To recalculate the random numbers using the RAND function,

Step_1: Select the Formulas tab.

Step_2: In the Calculation group, select the Calculate Now command.

Or you can press the F9 button to regenerate the random numbers.

### Availability

 Excel for Microsoft 365 Excel 2016 Excel for Microsoft 365 for Mac Excel 2016 for Mac Excel for the web Excel 2013 Excel 2021 Excel 2010 Excel 2021 for Mac Excel 2007 Excel 2019 Excel for Mac 2011 Excel 2019 for Mac Excel Starter 2010

### Remarks

• The RAND function doesn’t require any argument.
• It regenerates each time a workbook is opened or any change occurs.
• Press the F9 key to recalculate the random numbers.

## Conclusion

The RAND function is one of the math and trigonometry functions in Excel. If you have any questions regarding the RAND function, please comment below. Thanks!

Rate this post