How to Use RAND and RANDBETWEEN Functions in Excel

Watch Video: Rand and Randbetween Excel Functions

Generate Random Numbers using Excel Functions

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.

Excel VBA Master Tool Kit 
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.

RAND Function

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

RANDOM NUMBERS

RANDBETWEEN FUNCTION to Generate Random Numbers

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.​

RANDBETWEEN Function

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

RANDBETWEEN Function

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

RAND Function

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

RAND Function

 

Please comment with your questions or feedback related to this article. 

Want to learn more similar tricks? Please subscribe to us or follow us.

Keep Learning!!

Recommended Articles

Similar Posts

Correlation in excel
|

Correlation in Excel: coefficient, matrix and graph

BySumit Shrimal

This tutorial teaches the basics of correlation in Excel. It shows how to find a correlation coefficient, make a correlation matrix, and understand the results.
Correlation is one of the easiest calculations you can do in Excel. Even though it’s easy, it helps a lot in understanding how two or more things are related. Excel has all the tools you need to do a correlation analysis—you just need to know how to use them

How to Use Array Function in Excel
| |

How to Use Array Function in Excel

BySumit Shrimal

In this tutorial, you’ll learn what an Excel array formula is, how to enter it properly, and how to use array constants and array functions.
Array formulas are a very powerful tool in Excel, allowing you to do multiple calculations with a single formula. One array formula can replace many regular formulas. However, most users—around 90%—have never used them because they seem intimidating to learn.
Array formulas are known to be one of the trickiest Excel features to understand. The goal of this tutorial is to make learning them as easy and simple as possible

Leave a Reply

Your email address will not be published. Required fields are marked *

Excel VBA Master Tool Kit