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

Excel Formulas

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

DATEDIF

  • May 31, 2023
Definition: DATEDIF is a function that returns the difference between two dates in months, days, or years. Syntax: =DATEDIF(start_date, end_date, unit) Situation: This formula is suitable when you...
Read More

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

DATEVALUE

  • May 31, 2023
Definition: DATEVALUE is a function that returns the serial number of a date based on a text string. Syntax: =DATEVALUE(date_text) Situation: This formula is suitable when you need...
Read More

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

CHAR

  • May 31, 2023
Definition: CHAR is a function that returns the character specified by a number. Syntax: =CHAR(number) Situation: This formula is suitable when you need to convert a number to...
Read More

CHIDIST

  • May 31, 2023
Definition: CHIDIST is a function that returns the one-tailed probability of the chi-squared distribution. Syntax: =CHIDIST(x, degrees_freedom) Situation: This formula is suitable when you need to find the...
Read More

CHIINV

  • May 31, 2023
Definition: CHIINV is a function that returns the inverse of the one-tailed probability of the chi-squared distribution. Syntax: =CHIINV(probability, degrees_freedom) Situation: This formula is suitable when you need...
Read More

CHITEST

  • May 31, 2023
Definition: CHITEST is a function that tests the independence of two sets of data. Syntax: =CHITEST(actual_range, expected_range) Situation: This formula is suitable when you need to test whether...
Read More

CHOOSE

  • May 31, 2023
Definition: CHOOSE is a function that returns a value from a list of values based on a specified index. Syntax: =CHOOSE(index_num, value1, [value2], ...) Situation: This formula is...
Read More