00:00Okay guys, I need to show you something. I get this question regularly on my social media platform
00:04like YouTube and TikTok. How do you generate random percentage like this? Well, this is how
00:09you do it. Yes, we all know that in order to say 10%, you type 0.1, change the cell
00:14formatting
00:14to percentage, and that's how you get 10%. And you might say, why don't you use the function
00:18called ran between and say 0,1, and then hit enter. But you see, it only should give you either
00:230 or 1 to indicate 100%. How do you get the numbers in between? Basically, you have to
00:28change the second argument to 10,000 because that's how the percentage are represented in
00:32Excel, and hit enter. But you can see that you get numbers in a scale of 100,000. So to
00:37mitigate
00:37that, just divide it by 10,000 like this, and you get percentage nicely done. Now apply to
00:42the rest of the row like this. Now if you want to display multiple decimal places, select the
00:46cell, control 1, and after that in percentage here, you're going to change the two decimal
00:50place, and there you have it.
