Sigma Squared

Blog

COUNTBLANK

  • May 31, 2023
Definition: COUNTBLANK is a function that counts the number of blank cells in a range. Syntax: =COUNTBLANK(range) Situation: This formula is suitable when you need to count the...

COSH

  • May 31, 2023
Definition: COSH is a function that returns the hyperbolic cosine of a number. Syntax: =COSH(number) Situation: This formula is suitable when you need to find the hyperbolic cosine...

COS

  • May 31, 2023
Definition: COS is a function that returns the cosine of an angle. Syntax: =COS(number) Situation: This formula is suitable when you need to find the cosine of an...

CORREL

  • May 31, 2023
Definition: CORREL is a function that returns the correlation coefficient between two sets of data. Syntax: =CORREL(array1, array2) Situation: This formula is suitable when you need to find...

CONVERT

  • May 31, 2023
Definition: CONVERT is a function that converts a number from one measurement system to another. Syntax: =CONVERT(number, from_unit, to_unit) Situation: This formula is suitable when you need to...

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

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

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

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

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