’m starting to get used to these functions now, well a BIT anyway (get it?)...

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the BITLSHIFT function.

Now this is more like it. Finally, we get to functions used all of the time by your typical Excel user. Not.

In probability theory and statistics, the binomial distribution with parameters n and p is the discrete probability distribution of the number of successes in a sequence of n independent success / failure experiments, each of which yields success with probability p.

In probability theory and statistics, the binomial distribution with parameters n and p is the discrete probability distribution of the number of successes in a sequence of n independent success / failure experiments, each of which yields success with probability p. Almost the same as last time’s function, here at SumProduct, we like to demonstrate it’s not just TV companies that show repeats. ...

Almost the same as last time’s function, here at SumProduct, we like to demonstrate it’s not just TV companies that show repeats. Almost the same as last time’s function, here at SumProduct, we like to demonstrate it’s not just TV companies that show repeats. Almost the same as last time’s function, here at SumProduct, we like to demonstrate it’s not just TV companies that show repeats…

In probability theory and statistics, the binomial distribution with parameters n and p is the discrete probability distribution of the number of successes in a sequence of n independent success / failure experiments, each of which yields success with probability p.

This function converts a binary number (base two) to an octal number (base eight)...

We don’t want to put the hex on this function, but this converts a binary number (base two) to a hexadecimal number (base 16)...

This function converts a binary number (base two) to a decimal number (base 10)...