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

Excel Formulas

HYPERLINK

  • May 31, 2023
Definition: HYPERLINK is a function that creates a hyperlink to a specified location. Syntax: =HYPERLINK(link_location, [friendly_name]) Situation: This formula is suitable when you need to create a hyperlink...
Read More

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

FV

  • May 31, 2023
Definition: FV is a function that returns the future value of an investment. Syntax: =FV(rate, nper, pmt, [pv], [type]) Situation: This formula is suitable when you need to...
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