Skip to content
# How to Use RAND and RANDBETWEEN Functions in Excel

# RAND Function

# RANDBETWEEN Function

TIP:
Values derived from RAND and RANDBETWEEN functions changes each time worksheet is refreshed/ edited/open/changed. So please ensure to Paste Values the formula output so that database is not changed.
## Similar Posts

### EXCEL FUNCTION – IF

### EXCEL FUNCTION – REPT

### EXCEL FUNCTION – FIND

### EXCEL FUNCTION – INT

### EXCEL FUNCTION – SEARCH

### EXCEL FUNCTION – COUNTBLANK

We have got many instances where we needed to generate a random database or values. “RAND function” is very useful for users who creates random database for various types of working and analysis.

“RAND Function” generates values between 0 to less than 1. We always have output of the “RAND function” in decimals. The formula of function is very simple because it has no arguments and provides the random output.

Syntax: =RAND()

**Example:** Suppose we need to create a database for the various types of stationery products and their prices for a month.

There is one way to mention the random product prices one by one or we can use the “RAND function” to make the work easy. Here we will go ahead with using function.

Drag the formula to respective cells. i.e. Select Column + Ctrl + D

RANDBETWEEN Function is like the function “RAND” that we leant in above topic. RANDBETWEEN function is used where user needs integer values (not decimal) and between a predefined range.

Syntax: RANDBETWEEN(bottom, top)

Here, “bottom” means the lower value and “top” means higher value in range that you want

Example: You want to prepare a random database for volume of books in a books store with minimum quantity of 10 units and maximum quantity of 100 units. So here we need the various book name and random number of books.

Drag the formula to respective cells. i.e. Select Column + Ctrl + D

Select the data in column -> Menu- > Home-> Copy

Go to -> Menu- > Home-> Paste Values

Please comment your questions or feedback related to this article.

Want to learn more similar tricks. Please subscribe us or follow us from the left Social Media Icon.

Keep Learning!!

In an “IF function” there will be two output i.e. TRUE or FALSE since either the statement will be “TRUE” or “FALSE”. If the statement is matching or correct, then output will be “TRUE” or if the statement is not matching or not correct then the output will be “FALSE

REPT function is used to repeat the text or cell reference to multiple times

FIND function is used to find the position of text, or character in an available string.

INT function is used to round down the numeric value to nearest integer. INT Function has one required argument i.e. number.

SEARCH function is used to find “position of character or text” in an available cell and this function is NOT case sensitive.

COUNTBLANK function is used to get the total count of Blank or Empty cell in range.

COUNTBLANK Function has one required argument i.e. range.