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

Excel Formulas

CLEAN

  • May 31, 2023
Definition: CLEAN is a function that removes all non-printable characters from a string. Syntax: =CLEAN(text) Situation: This formula is suitable when you need to remove non-printable characters, such...
Read More

CODE

  • May 31, 2023
Definition: CODE is a function that returns the ASCII code of the first character in a text string. Syntax: =CODE(text) Situation: This formula is suitable when you need...
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

COLUMN

  • May 31, 2023
Definition: COLUMN is a function that returns the column number of a cell reference. Syntax: =COLUMN(reference) Situation: This formula is suitable when you need to retrieve the column...
Read More

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

COLUMNS

  • May 31, 2023
Definition: COLUMNS is a function that returns the number of columns in an array. Syntax: =COLUMNS(array) Situation: This formula is suitable when you need to retrieve the number...
Read More

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

COMBIN

  • May 31, 2023
Definition: COMBIN is a function that returns the number of combinations for a given number of items. Syntax: =COMBIN(number, number_chosen) Situation: This formula is suitable when you need...
Read More

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

CONFIDENCE

  • May 31, 2023
Definition: CONFIDENCE is a function that returns the confidence interval for a population mean. Syntax: =CONFIDENCE(alpha, standard_dev, size) Situation: This formula is suitable when you need to calculate...
Read More