How to Use Excel RANDBETWEEN Function in Office 365?
Tags: excelfunctions, excelrandbetweenfunc
Published: 2020-08-26 03:34:09

---
title: How to Use Excel RANDBETWEEN Function in Office 365?
published: true
date: 2020-08-25 07:02:02 UTC
tags: ExcelFunctions,ExcelRANDBETWEENFunc
canonical_url: https://geekexcel.com/how-to-use-excel-randbetween-function-in-office-365/
---

## RANDBETWEEN Function in Excel:

![RANDBETWEEN Function in Excel](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/4-17.png)<figcaption id="caption-attachment-12547">RANDBETWEEN Function in Excel</figcaption>

In this guide, you will learn the usage of **Excel RANDBETWEEN Function in Office 365** with its syntax, description, and examples. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)



## RANDBETWEEN Function – Description:

- This function **returns the random integer number between the two specified values**.
- Excel returns a new random number each time the worksheet is calculated.
- For example, **RANDBETWEEN(18,30)** returns **24 (varies)** random number.

## Syntax:

**=RANDBETWEEN(bottom, top)**

### Argument Explanation:

**Bottom** – The smallest value ( **starting value** ) of the range.

**Top** – The largest value ( **ending value** ) of the range.

### Note:

- You can also use **negative integers** as argument values.
- Use the following formula to calculate the random number between two numbers ( **a and b** ).
- “**=RAND()\*(b-a)+a**“
- If you want to generate a set of random numbers in multiple cells, you need to select the cells then, type RANDBETWEEN(bottom, top) in the formula bar, and press the following keys: CTRL ENTER

## Examples:

Let’s take a look at the below examples.

### Example 1:

- Kindly, refer to the below screenshot.
- You can see the **bottom** (the smallest range) values in **Column A** , **top** (the largest range) values in **Column B**.
- As a result of the RANDBETWEEN Function, the generated random values are listed in **Column C**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-67.png)<figcaption id="caption-attachment-12538">Example 1</figcaption>

### Example 2:

- If you want to generate a set of random numbers in multiple cells, you need to select the cells then, type RANDBETWEEN(bottom, top) in the formula bar, and press the following keys: CTRL ENTER
- In the following example, we have given the range **between 1 and 1000**. Thus, it will return the random numbers between the specified numbers.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-52.png)<figcaption id="caption-attachment-12539">Example 2</figcaption>

### Example 3:

- If any argument is a non-numeric value like a single alphabet or string, it returns **#NAME?** Error.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-40.png)<figcaption id="caption-attachment-12540">Example 3</figcaption>

## Closure:

In this article, you can understand the usage of the **Excel RANDBETWEEN Function in Office 365** with its syntax, description, and examples. Kindly, share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Articles:

- **RAND Function in Excel**

### Read Also:

- [How to Use Excel “FACT Function” in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-fact-function-in-office-365-with-examples/)
- [How to Use Excel LOG Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-log-function-in-office-365-with-examples/)