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!!
FIND function is used to find the position of text, or character in an available string.
LARGE function is used to get the Largest k-th value from the range.
LARGE Function has two required arguments i.e. array, and k
The ROMAN function in Excel converts numbers into Roman numerals. It’s useful when you need to display numbers in the Roman numeral format, such as for dates, titles, or other specific purposes. The function allows you to choose how “traditional” or simplified the Roman numeral should be. To use the ROMAN function, you just need to enter the number you want to convert, and Excel will do the rest
An easy way to transform an array or range into a column with the TOCOL function. The ability to transpose data from columns to rows and in reverse has been in Excel for quite a…
AVERAGE function is used to get the average of numbers. Function applies formula i.e. average = Sum of all values / (Divided by) number of items.
The tutorial explains how to use the CHOOSE function in Excel, showing you the basics and some interesting examples. While CHOOSE might seem simple on its own, when you combine it with other functions, it can be powerful. Essentially, the CHOOSE function helps you pick a value from a list based on its position. The tutorial also covers some advanced ways to use CHOOSE that you might find very useful.