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 with your questions or feedback related to this article.
Want to learn more similar tricks? Please subscribe to us or follow us.
Keep Learning!!
What is Absolute Value in Excel? The absolute value of a number is its distance from zero on the number line, regardless of direction, so it’s always a non-negative number. The ABS function in Excel…
Watch: How to use WEEKNUM Function in Excel? What is WEEKNUM Function? The WEEKNUM function in Excel returns the week number of a given date. It is a DATE and TIME function that can be…
This guide will show you quick and easy methods to find the number of days between dates in Excel.
Do you need to know how many days are between two dates? Maybe you want to find out the days between today and a date in the past or future, or just count the working days between two dates? Whatever you need, one of the examples below will help you find the solution
“NETWORKDAYS” function is very helpful feature in the Microsoft excel to calculate the working days from a particular period excluding “Saturday and Sundays”. NETWORKDAYS function subtract the Start Day from the End Date provided.
ROWS function is used to get the total count of rows in an array or in cells range in an excel worksheet.
Watch: How to use VLOOKUP Function in Excel? What is VLOOKUP Function? The VLOOKUP function in Excel searches for a value in a table and returns a corresponding value from another column in the same row…