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()
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!!
VBA Code to Count Color Cells With Conditional Formatting Have you ever got into situation in office where you need to count the cells with specific color in conditional formatted Excel sheet? If yes then…
ROUND function rounds the number value to nearest digit mentioned in argument.
ROUND function has two required arguments i.e. number and num_digits
SMALL function is used to get the Smallest k-th value from the range.
SMALL Function has two required arguments i.e. array, and k
https://youtu.be/HmJL_y93pAs WEEKNUM function helps to calculate the week number of the given date in a year. It considers 1st January as first week by default and through the output for the given input date. Syntax:…
You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data. So here you may use…
Microsoft Excel “NOW” function is used to get the current Date and Time. It is very useful function and can be used in many ways.