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

Month: May 2023

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

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

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

MINUTE

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

MINA

  • May 31, 2023
Definition: MINA is a function that returns the minimum value in a range of cells, and treats text and logical values as numbers. Syntax: =MINA(number1, [number2], ...) Situation:...
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

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

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

MAXA

  • May 31, 2023
Definition: MAXA is a function that returns the maximum value in a range of cells, and treats text and logical values as numbers. Syntax: =MAXA(number1, [number2], ...) Situation:...
Read More

LOWER

  • May 31, 2023
Definition: LOWER is a function that converts all uppercase letters in a text string to lowercase. Syntax: =LOWER(text) Situation: This formula is appropriate when you need to convert...
Read More