Excel tutorials

In this part we are going to simulate a coin toss. We are going to simulate flipping a coin 10 times and see what the outcome gets.

This are going to be pretty easy – we are going to make use of the =RANDBETWEEN() function.

As you probably know the randbetween takes two arguments, a bottom and a top value, and we will get a random number between those two levels.

Here we simple set bottom as 0 and top as 1.

=RANDBETWEEN(0;1)

If we drag the above formula down we will get a bunch of zeroes and ones.

To make this more meaningful we are going to wrap this into a IF-statement.

If Randbetween gives us a 0 – we will set that as “TAILS”, otherwise it is “HEAD”.

The complete formula will look like this: