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

Excel Formulas

LOGNORMDIST

  • May 31, 2023
Definition: LOGNORMDIST is a function that returns the cumulative distribution function for a specified log-normal distribution. Syntax: =LOGNORMDIST(x, mean, standard_dev, cumulative) Situation: This formula is appropriate when you...
Read More

LOOKUP

  • May 31, 2023
Definition: LOOKUP is a function that searches for a value in a range of cells and returns a corresponding value from the same position in another range of...
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

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

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

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