Please note javascript is required for full website functionality.

A To Z of Excel Functions

A To Z of Excel Functions

A to Z of Excel Functions: The BITXOR Function

17 March 2017

This function returns a bitwise ‘XOR’ of two numbers (XOR was first introduced in Excel 2013 and at the current rate of publishing these articles we should get to this one by 2044)...


A to Z of Excel Functions: The BITRSHIFT Function

13 March 2017

It’s time to find thee antidote to the recent BITLSHIFT function and you shouldn’t feel bitter (BITR?).


A to Z of Excel Functions: The BITOR Function

3 March 2017

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


A to Z of Excel Functions: The BITLSHIFT Function

20 February 2017

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


A to Z of Excel Functions: The BITAND Function

13 February 2017

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


A to Z of Excel Functions: The BINOM.INV Function

6 February 2017

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.


A to Z of Excel Functions: The BINOM.DIST.RANGE Function

23 January 2017

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. ...


A to Z of Excel Functions: The BINOMDIST Function

16 January 2017

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…


A to Z of Excel Functions: The BINOM.DIST Function

9 January 2017

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.


A to Z of Excel Functions: The BIN2OCT Function

6 January 2017

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


Newsletter