This function sounds like something you calculate whilst swinging from the chandeliers...

Have you reached your CEILING?

This function returns the cumulative interest paid (“cumulative interest payment”) on a loan between a designated start_period and end_period given a constant periodic discount rate...

Look, before we go anywhere here, this function is for advanced users only. If you use the CALL function incorrectly, you might be looking for a new computer – well at best, you’ll have to restart your PC....

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

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

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