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

Excel Formulas

LCID

  • May 31, 2023
Definition: LCID is a function that returns the locale identifier for a given language. Syntax: =LCID(language) Situation: This formula is appropriate when you need to find the locale...
Read More

LEN

  • May 31, 2023
Definition: LEN is a function that returns the number of characters in a text string. Syntax: =LEN(text) Situation: This formula is appropriate when you need to find the...
Read More

LINEST

  • May 31, 2023
Definition: LINEST is a function that calculates the parameters of a linear regression line for a given set of data. Syntax: =LINEST(known_y's, [known_x's], [const], [stats]) Situation: This formula...
Read More

LN

  • May 31, 2023
Definition: LN is a function that returns the natural logarithm of a number. Syntax: =LN(number) Situation: This formula is appropriate when you need to find the natural logarithm...
Read More

LOG

  • May 31, 2023
Definition: LOG is a function that returns the logarithm of a number to a specified base. Syntax: =LOG(number, [base]) Situation: This formula is appropriate when you need to...
Read More

LOG10

  • May 31, 2023
Definition: LOG10 is a function that returns the base 10 logarithm of a number. Syntax: =LOG10(number) Situation: This formula is appropriate when you need to find the base...
Read More

LOGEST

  • May 31, 2023
Definition: LOGEST is a function that calculates an exponential curve that fits a set of data points using the least squares method. Syntax: =LOGEST(known_y's, [known_x's], [const], [stats]) Situation:...
Read More

LOGINV

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

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