How to Flip Heads and Tails in Google Sheets
Learn how to randomly flip heads and tails in Google Sheets using the RANDBETWEEN function and the CHOOSE formula, allowing for thousands of random selections effortlessly.
I'm going to show you how to flip heads and tails thousands of times. When we flip heads and tails, 50% heads, 50% tails. And we can do that by using the formula choose. We can choose one, and we can offer a choice. Heads here. And tails, and then we're going to choose one. Copy paste this, and we choose two, it's going to choose tails. How do we do this randomly? And how do we not have to write heads each time? So we're going to use equals, choose, we're going to do rand between one, comma, two. That's it. RANDBETWEEN() 1, 2. That'll choose a random number between 1 or 2, inclusive. And the options are going to be b2, b3. Now if we want to make this absolute so we can copy paste this like thousands of times, we're going to put a dollar sign in front of the b, and in front of the 2, and in front of the b, and in front of the 3. That means , once we copy paste, this range won't change. 5 Ways to Generate Random Numbers Select Random From List in Google Sheets
We can copy paste this as many times as we want, and we're gonna get a random selection of heads or tails each and every time. And we can do this thousands of times if we want. 5 Ways to Generate Random Numbers Generate Short Random Codes or IDs