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

Excel Formulas

ISNUMBER

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

HYPGEOMDIST

  • May 31, 2023
Definition: HYPGEOMDIST is a function that returns the hypergeometric distribution for a specified set of parameters. Syntax: =HYPGEOMDIST(sample_s, number_sample, population_s, number_pop, [cumulative]) Situation: This formula is suitable when...
Read More

ISODD

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

IFS

  • May 31, 2023
Definition: IFS is a function that evaluates multiple conditions and returns a value corresponding to the first true condition. Syntax: =IFS(condition1, value1, [condition2, value2], ...) Situation: This formula...
Read More

INDIRECT

  • May 31, 2023
Definition: INDIRECT is a function that returns a reference to a range based on a text string. Syntax: =INDIRECT(ref_text, [a1]) Situation: This formula is suitable when you need...
Read More

FVSCHEDULE

  • May 31, 2023
Definition: FVSCHEDULE is a function that returns the future value of an initial principal after applying a series of compound interest rates. Syntax: =FVSCHEDULE(principal, schedule) Situation: This formula...
Read More

GAMMADIST

  • May 31, 2023
Definition: GAMMADIST is a function that returns the gamma distribution for a specified set of parameters. Syntax: =GAMMADIST(x, alpha, beta, [cumulative]) Situation: This formula is suitable when you...
Read More

GAMMAINV

  • May 31, 2023
Definition: GAMMAINV is a function that returns the inverse of the gamma cumulative distribution for a specified set of parameters. Syntax: =GAMMAINV(probability, alpha, beta) Situation: This formula is...
Read More

GAMMALN

  • May 31, 2023
Definition: GAMMALN is a function that returns the natural logarithm of the gamma function. Syntax: =GAMMALN(x) Situation: This formula is suitable when you need to find the natural...
Read More

GAMMALN.PRECISE

  • May 31, 2023
Definition: GAMMALN.PRECISE is a function that returns the natural logarithm of the gamma function, using a more precise calculation method. Syntax: =GAMMALN.PRECISE(x) Situation: This formula is suitable when...
Read More