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

Excel Formulas

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

NETWORKDAYS

  • May 31, 2023
Definition: NETWORKDAYS is a function that calculates the number of working days between two given dates. Syntax: =NETWORKDAYS(start_date, end_date, [holidays]) Situation: This formula is appropriate when you need...
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

MID

  • May 31, 2023
Definition: MID is a function that returns a specified number of characters from the middle of a text string. Syntax: =MID(text, start_num, num_chars) Situation: This formula is appropriate...
Read More

LARGE

  • May 31, 2023
Definition: LARGE is a function that returns the nth largest value in a data set. Syntax: =LARGE(array, k) Situation: This formula is appropriate when you need to find...
Read More