This post will guide you how to use** Excel RANDBETWEEN function** with syntax and examples in Microsoft excel.

Table of Contents

### Description

The Excel RANDBETWEEN function returns a random integer number that is between the numbers you specify. Each time when the worksheet is calculated or opened, a new random integer number is generated. So you can use the RANDBETWEEN function to generate a random integer number between tow given values.

The RANDBETWEEN function is a build-in function in Microsoft Excel and it is categorized as a Math and Trigonometry Function.

The RANDBETWEEN function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

### Syntax

The syntax of the RANDBETWEEN function is as below:

=RANDBETWEEN (bottom,top)

Where the RANDBETWEEN function arguments are:

**bottom**-This is a required argument. The smallest integer number that RANDBETWEEN Function will return.**top**– This is a required argument. The largest integer number that RANDBETWEEN Function will return.

** Note:**

- If the bottom argument is greater than the given top value, the RANDBETWEEN function will return
**#NUM! Error.** - If either of the given arguments are non-numeric, this function will return
**#VALUE! Error**.

### Excel RANDBETWEEN Function Examples

The below examples will show you how to use Excel RANDBETWEEN Function to generate a random integer between two supplied integer numbers.

**1#** get a random number between 1 and 200, enter the following formula in Cell B1.

=RANDBETWEEN(1,200)

**2#** get a random number between -10 and 10, enter the following formula in Cell B2.

=RANDBETWEEN(-10,10)

### Related Functions

- Excel RAND function

The Excel RAND function returns a random real number that is greater than or equal to 0 and less than 1. The syntax of the RAND function is as below:=RAND ()…

### More Excel Randbetween Function Examples

- Generate Random Character Strings

To generate random character strings in excel, you should be generate random numbers, letters, and special characters. We have talked that how to generate a random number string with Excel RANDBETWEEN function in excel… - Generate Random Passwords

To generate a Random and secure password in Excel, you can use a combination of the CHAR function, the RANDBETWEEN function and concatenation operator to build a new Excel formula…. - Randomly Select Cells

If you want to randomly select cells from a range of cells, you can use a formula based on the INDEX function, the RANDBETWEEN function and the Rows function…..

## Leave a Reply

You must be logged in to post a comment.