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.

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()

Examples of RAND Function in Excel

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 “()”.

Usage Guide of RAND Function in Excel

Step_4: Press ENTER.

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

Usage Guide of RAND Function in Excel

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

Usage Guide of RAND Function in Excel

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.

Recalculate Random Numbers in Excel

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!

Similar Posts

Leave a Reply

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