Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelRANDBETWEEN Function in Excel

# RANDBETWEEN Function in Excel

In this post, you will learn about the RANDBETWEEN Function in Excel, how to use in your excel spreadsheets.

## Syntax

`=RANDBETWEEN(bottom, top)`

The syntax has two arguments

• bottom â€“ This argument holds the first number, which is the lower value of the range
• top â€“ This argument holds the second number, which is the upper value of the range.

## How to use RANDBETWEEN in Excel?

• The function returns a random number between the range of the given two numbers. And the value changes as the function revaluates each time the spreadsheet is calculated or opened.
• To start with entering the numbers in an excel sheet, and in a new cell enter the syntax of the function. Highlight the numbers to include them in the function.
• Press enter to display the answer and use the fill handle to apply the function in the rest of the data.
• The below example uses the same values for the arguments, but when recalculated gives different answers.

• The syntax accepts positive, negative, and decimal numbers.
• The function returns a different value after each recalulation of the syntax.
• Note that the bottom argument value has to be less than the top argument value, or the function will return #NUM! error.
• To keep the answer constant, select an empty cell and enter the syntax in the formula bar. Press f9, this performs the function once, giving a static result.
• When the answer is seen displayed in the formula tab, this means the answer is static.

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