Sigma Squared

Blog

BIN2HEX

  • May 31, 2023
Definition: BIN2HEX is a function that converts a binary number to hexadecimal. Syntax: =BIN2HEX(number, [places]) Situation: This formula is suitable when you need to convert a binary number...

BIN2DEC

  • May 31, 2023
Definition: BIN2DEC is a function that converts a binary number to decimal. Syntax: =BIN2DEC(number) Situation: This formula is suitable when you need to convert a binary number to...

BETAINV

  • May 31, 2023
Definition: BETAINV is a function that returns the inverse of the cumulative beta probability density function. Syntax: =BETAINV(probability, alpha, beta, [lower], [upper]) Situation: This formula is suitable when...

BETADIST

  • May 31, 2023
Definition: BETADIST is a function that returns the cumulative beta probability density function. Syntax: =BETADIST(x, alpha, beta, [lower], [upper]) Situation: This formula is suitable when you need to...

BESSELY

  • May 31, 2023
Definition: BESSELY is a function that returns the Bessel function of the second kind for a complex number. Syntax: =BESSELY(x, n) Situation: This formula is suitable when you...

BESSELK

  • May 31, 2023
Definition: BESSELK is a function that returns the modified Bessel function of the second kind for a complex number. Syntax: =BESSELK(x, n) Situation: This formula is suitable when...

BESSELJ

  • May 31, 2023
Definition: BESSELJ is a function that returns the Bessel function of the first kind for a complex number. Syntax: =BESSELJ(x, n) Situation: This formula is suitable when you...

BESSELI

  • May 31, 2023
Definition: BESSELI is a function that returns the modified Bessel function of the first kind for a complex number. Syntax: =BESSELI(x, n) Situation: This formula is suitable when...

BASE

  • May 31, 2023
Definition: BASE is a function that converts a number from one base to another. Syntax: =BASE(number, from_base, [to_base]) Situation: This formula is suitable when you need to convert...

BAHTTEXT

  • May 31, 2023
Definition: BAHTTEXT is a function that converts a number to Thai text. Syntax: =BAHTTEXT(number) Situation: This formula is suitable when you need to convert a number to Thai...