Hello friends,
Today we will learn about Excel formula Randbetween, what this function does. It create a random data between given range. We will learn about this in this blog in details.
1. Rand Function
2. Randbetween for Numbers
3. Randbetween for Random text
4. Using cell reference
5. Paste as values
1. Rand Function
Rand function is useful when we want to create a random data this function displays only numeric values in decimals
Simply put "=" sign and type rand and this function simply create a numeric value in decimal
=Rand() will given result as 0.0964509 and it will change on every updation.
This function will always gives result like this.
2. Randbetween for Numbers
Now come to Randbetween function this function is different from rand function,
Rand function has no parameters but Randbetween has two parameters like :- Bottom value and Top value
Bottom - This is the starting value i.e. the figure of the data will not below from this value
Top - This is the end value i.e. the figure of the data will not be above from this value
Syntex of the formula is as follows :-
RANDBETWEEN(Bootom,Top)
Here is the example as follows :-
In this table you will see that the bottom value is not below number 11 and the top value is not bigger than 101 because we have set the limit.
3. Randbetween for Random text
Now this is the another use of Randbetween formula for the text values like:- Male, Female, East, West, North, South, etc
Randbetween by Cell References
We can generate a random data by putting cell reference, just see the below mentioned example:-
=CHOOSE(RANDBETWEEN(1,2),$D$2,$D$3)
In this case if we change the text figure in the cell the data figure will automatically will be changed.
Randbetween for Random date
In this example we can put a random date in the given table:-
Paste As Values
When we are working with spreadsheets with randbetween formulas then every time we update our sheet and same time the data will change but if we copy that data and paste on the same place as values the data will be freeze and not change with every updation. For doing that first select the entire random data range and then copy the entire data range then right click on the same place from the mouse then paste special then click on values and press ok the data will be freeze and will not change on every updation.
goodbye for now
Narendra
