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

Excel Formulas

NORMSDIST

  • May 31, 2023
Definition: NORMSDIST is a function that returns the standard normal cumulative distribution for a specified value. Syntax: =NORMSDIST(z) Situation: This formula is appropriate when you need to calculate...
Read More

MINVERSE

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

NORMSINV

  • May 31, 2023
Definition: NORMSINV is a function that returns the inverse of the standard normal cumulative distribution for a specified probability. Syntax: =NORMSINV(probability) Situation: This formula is appropriate when you...
Read More

MIRR

  • May 31, 2023
Definition: MIRR is a function that calculates the modified internal rate of return for a series of periodic cash flows. Syntax: =MIRR(values, finance_rate, reinvest_rate) Situation: This formula is...
Read More

NOT

  • May 31, 2023
Definition: NOT is a function that returns the opposite of a logical value. Syntax: =NOT(logical) Situation: This formula is appropriate when you need to get the opposite of...
Read More

MMULT

  • May 31, 2023
Definition: MMULT is a function that returns the matrix product of two given arrays. Syntax: =MMULT(array1, array2) Situation: This formula is appropriate when you need to find the...
Read More

MOD

  • May 31, 2023
Definition: MOD is a function that returns the remainder of a division operation. Syntax: =MOD(number, divisor) Situation: This formula is appropriate when you need to find the remainder...
Read More

MODE

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

MONTH

  • May 31, 2023
Definition: MONTH is a function that returns the month component of a given date. Syntax: =MONTH(serial_number) Situation: This formula is appropriate when you need to find the month...
Read More

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