In this post, we look at How to Use RAND and RANDBETWEEN Function in Google Sheets. Previously I have posted about the logical functions in Google Sheets. The tutorial was about the logical functions which works out for the formula based work and you can do that in the spreadsheet.
In case of the random numbers, random number generation and also having a range for the randomness, you can make use of these two functions for the google spreadsheet. The same set of the functions would be working with the zoho sheet and the excel too. So you should check it out and this would help you establish a base from which you can use the formula in most of the operations where you need it.
Let's take a look at one of the tutorial where you can learn how to use RAND and RANDBETEEN function in Google Sheets.
Let's first take out the spreadsheet. And then you can make sure to select one cell so that we can test out some random data and it's relative operation.
RAND() Function
You can use the below formula to get some random number generated in one of the cell.
=rand()
And that would show the result something like this.
0.7568614437
And now we can say that range between the randomness and then we can use the below function.
RANDBETWEEN() Function
You can check out the random number generated in between the range.
=RANDBETWEEN(1,100)
You can also mix and match between the IF and Else type of the conditions for this type of the programs.
Take this example formula where you can see how this can be done.
=IF(RAND()<0.5, "Yes", "No")
This was one of the use case of the random number functions. Most of the people make use of it for their random cell data to be selected on certain condition.And you can also make use of the same for building the condition based spreadsheet where you can filter the data based on some random number based range too. You can find plenty of use case and also the variety of cases for the random number within the ranges.
I have seen most of the people making use of the range for certain geographic and other types of the options. I can tell you from the experience that when you make use of such formulas always pay attention to the ranges because you would notice that there are times when range has to be exact and not random on every refresh. You can control that sort of the issue if you choose the range within limited numbers. That would give you much better direction.
Now that being said, I have made sure that the content like this gets posted every week. And this way I can cover a lot of content on education community. I am going to be covering cloud computing, linux and other options too. But it all comes down to what you wish to do with the content matters. I hope that the content for the college and university gets used like this.
If you like my content, please share and like the content. That would go a longway to help me get into the algorithm. As most of my content has been pretty low and also not has helped on that context much. I feel that once I get enough videos with the views from variety of places in the world, that would help with my overall account health too. So your help on getting the likes and the shares to the videos is much appreciated.
I'll add more spreadsheet tutorial by the next week. :)
Thanks for your contribution to the STEMsocial community. Feel free to join us on discord to get to know the rest of us!
Please consider delegating to the @stemsocial account (85% of the curation rewards are returned).
You may also include @stemsocial as a beneficiary of the rewards of this post to get a stronger support.
The more I use spreadsheets, the more respect I gain for them. For a long time after I finished school, I didn't use them, but now I'm a teacher, and since I've begun using them more and more, I've learned a lot about the functions they offer, and how powerful they are.
I reckon that you could use that random function to create a simulated dice roll and create a mini game of sorts. Like I said, my respect for spreadsheets is growing exponentially the more I learn about them.
Thank you for highlighting this function.