Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelRAND Function in Excel

# RAND Function in Excel

In this post, you will learn about the Rand function in Excel and how to use it in your excel spreadsheets.

Syntax

=RAND()

This syntax has no arguments.

## How to use RAND Function in Excel?

• The function returns a random number in the excel spreadsheet.
• The numbers are greater than or equal to 0, but less than 1, that is the answers are decimal numbers.
• A new number is displayed every time the function is used in the excel sheet.

If you want to use the function to find a random number, but you donâ€™t want the number to change every time then similar to the previous example, enter the syntax in the formula bar or a random cell and press F9, this will convert the formula into the number.

• A simple formula which uses the RAND Function, to find a random number between any two numbers a and b =RAND() * ( b â€“ a ) + a
• The example below, demonstrates the above formula, with the values a=3 & b=6.

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021