RAND AND RANDBETWEEN FUNCTION

Complete Excel VBA Course

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.

Complete Excel VBA Course

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

RAND Function

RAND BETWEEN FUNCTION

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

Secrets of Excel Data Visualization: Beginners to Advanced Course

Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.

This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.

So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.

Excel VBA Course : Beginners to Advanced

We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion

This course is going to help you to excel your skills in Excel VBA with our real time case studies.

Lets get connected and start learning now. Click here to Enroll.

Similar Posts

Leave a Reply

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