Please note javascript is required for full website functionality.

A To Z of Excel Functions

A to Z of Excel Functions: The BIN2HEX Function

26 December 2016

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

A to Z of Excel Functions: The BIN2DEC Function

19 December 2016

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

A to Z of Excel Functions: The BETAINV Function

9 December 2016

Almost the same as last time’s function (BETA.INV), 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 BETA.INV Function

2 December 2016

In probability theory and statistics, the beta distribution is a family of continuous probability distributions defined on the interval [0, 1] parametrised by two positive shape parameters, denoted by ? (alpha) and ? (beta), that appear as exponents of the random variable and control the shape of the distribution...

A to Z of Excel Functions: The BETADIST Function

21 November 2016

In probability theory and statistics, the beta distribution is a family of continuous probability distributions defined on the interval [0, 1] parametrised by two positive shape parameters, denoted by ? (alpha) and ? (beta), that appear as exponents of the random variable and control the shape of the distribution..

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

18 November 2016

In probability theory and statistics, the beta distribution is a family of continuous probability distributions defined on the interval [0, 1] parametrised by two positive shape parameters, denoted by ? (alpha) and ? (beta), that appear as exponents of the random...

A to Z of Excel Functions: The BESSELY Function

14 November 2016

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

A to Z of Excel Functions: The BESSELK Function

11 November 2016

Bessel functions were first defined by the mathematician Daniel Bernoulli and then generalised by Friedrich Bessel as the canonical solutions y(x) of the differential equation...

A to Z of Excel Functions: The BESSELJ Function

7 November 2016

Bessel functions were first defined by the mathematician Daniel Bernoulli and then generalised by Friedrich Bessel as the canonical solutions y(x) of the differential equation...

A to Z of Excel Functions: The BESSELI Function

2 November 2016

Bessel functions were first defined by the mathematician Daniel Bernoulli and then generalised by Friedrich Bessel as the canonical solutions y(x) of the differential equation..