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

Excel Formulas

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

ISREF

  • May 31, 2023
Definition: ISREF is a function that returns TRUE if a value is a reference, and FALSE if it is not. Syntax: =ISREF(value) Situation: This formula is appropriate when...
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

ISTEXT

  • May 31, 2023
Definition: ISTEXT is a function that returns TRUE if a value is text, and FALSE if it is not. Syntax: =ISTEXT(value) Situation: This formula is appropriate when you...
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

INFO

  • May 31, 2023
Definition: INFO is a function that returns information about the current operating environment. Syntax: =INFO(type_text) Situation: This formula is suitable when you need to obtain information about the...
Read More

INT

  • May 31, 2023
Definition: INT is a function that rounds a number down to the nearest integer. Syntax: =INT(number) Situation: This formula is suitable when you need to round a number...
Read More

INTERCEPT

  • May 31, 2023
Definition: INTERCEPT is a function that returns the y-intercept of a linear regression line. Syntax: =INTERCEPT(known_y's, known_x's) Situation: This formula is suitable when you need to find the...
Read More

IPMT

  • May 31, 2023
Definition: IPMT is a function that calculates the interest payment for a given period of a loan or investment, assuming periodic, constant payments and a constant interest rate....
Read More

ISBLANK

  • May 31, 2023
Definition: ISBLANK is a function that returns TRUE if a cell is empty, and FALSE if it contains any value, including zero or a formula that returns an...
Read More