« Working with Time on Excel | Abhilash is on Holiday!!! :) » |
Hi there,
We all know RANDBETWEEN works only with numbers. But, why am I saying we can do random pic words using RANDBETWEEN. Is there any way we can do this? If you have any idea before reading the complete post, leave your idea using below comments section.
If you are new to this tip, walk with me.
Learn Formulas from here. We have FORMULAS CRASH COURSE tailored for you; try once if you like it.
RANDBETWEEN WORKS WITH NUMBERS:
...
As I already mentioned, this function works only to list the values in a cell randomly. This function is a very simple but very useful function (time saving function in many cases) when creating dummy data for experimenting on few of the features in Excel. This function helps to randomly pic one of the given scenarios and displays in the cells. It doesn't follow any particular method while displaying the random figures.
This is a basic introduction about RANDBETWEEN.
RANDBETWEEN WORKS WITH WORDS / CHARACTERS:
Here, say we have two genders and it has to be displayed randomly. So, we have either Male or Female version. Right? To do this, we will use CHOOSE function to work with words/characters to display randomly. Here how it is:
=CHOOSE(RANDBETWEEN(1,2),"Male","Female")
HOW THIS FORMULA WORKS:
CHOOSE function helps to choose the word related to what number RANDBETWEEN displays in INDEX PLACE. Say RANDBETWEEN displays 1 then CHOOSE will take MALE else 2 as FEMALE.
That's it. Magic Works!!!
DID YOU USE RANDBETWEEN?
If you have anything to share regarding this post, please feel free to post your comments, ideas, suggestions, or anything using below comments section.
If you like this post, please do share it on your social networking sites just by clicking on the icons placed around the blog.
If you want to support me for maintaining this blog, REGISTER here for free. You will be receiving all latest updates directly to your registered mail. We strongly follow data security.
SOME IMPORTANT LINKS:
How to Get Decimals using RANDBETWEEN
Test Cases can be changed Before Changing UnderPants
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments