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

Excel Formulas

MROUND

  • May 31, 2023
Definition: MROUND is a function that rounds a number to the nearest multiple of a specified value. Syntax: =MROUND(number, multiple) Situation: This formula is appropriate when you need...
Read More

MULTINOMIAL

  • May 31, 2023
Definition: MULTINOMIAL is a function that returns the factorial of a sum of values divided by the product of the factorials of the individual values. Syntax: =MULTINOMIAL(number1, [number2],...
Read More

N

  • May 31, 2023
Definition: N is a function that returns a value converted to a number. Syntax: =N(value) Situation: This formula is appropriate when you need to convert a value to...
Read More

NA

  • May 31, 2023
Definition: NA is a function that returns the error value #N/A, which indicates that a value is not available or not applicable. Syntax: =NA() Situation: This formula is...
Read More

NEGBINOMDIST

  • May 31, 2023
Definition: NEGBINOMDIST is a function that returns the negative binomial distribution of a given set of data. Syntax: =NEGBINOMDIST(number_f, number_s, probability_s) Situation: This formula is appropriate when you...
Read More

ISTEXT

  • May 31, 2023
Definition: ISTEXT is a function that returns TRUE if a value is text, and FALSE if it is not. Syntax: =ISTEXT(value) Situation: This formula is appropriate when you...
Read More

MDETERM

  • May 31, 2023
Definition: MDETERM is a function that returns the matrix determinant of a given array. Syntax: =MDETERM(array) Situation: This formula is appropriate when you need to find the matrix...
Read More

JIS

  • May 31, 2023
Definition: JIS is a function that converts a double-byte character set (DBCS) code to a single-byte character set (SBCS) code. Syntax: =JIS(text) Situation: This formula is appropriate when...
Read More

MEDIAN

  • May 31, 2023
Definition: MEDIAN is a function that returns the median value in a range of cells. Syntax: =MEDIAN(number1, [number2], ...) Situation: This formula is appropriate when you need to...
Read More

KURT

  • May 31, 2023
Definition: KURT is a function that returns the kurtosis of a data set, which is a measure of the peakedness and tails of the distribution. Syntax: =KURT(number1, [number2],...
Read More