Sigma Squared
Lexington, KY, USA
614-973-9100
Follow on:
Linkedin-in Twitter Youtube

Special Functions

SQRTPI

  • May 31, 2023
Definition: The SQRTPI function in Excel is used to find the square root of a number multiplied by pi. Syntax: ==SQRTPI(number). Situation: This formula is appropriate in situations...
Read More

GAMMALN

  • May 31, 2023
Definition: GAMMALN is a function that returns the natural logarithm of the gamma function. Syntax: =GAMMALN(x) Situation: This formula is suitable when you need to find the natural...
Read More

GAMMALN.PRECISE

  • May 31, 2023
Definition: GAMMALN.PRECISE is a function that returns the natural logarithm of the gamma function, using a more precise calculation method. Syntax: =GAMMALN.PRECISE(x) Situation: This formula is suitable when...
Read More

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

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

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

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