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

Blog

OCT2DEC

  • May 31, 2023
Definition: OCT2DEC is a function that converts an octal number to a decimal number. Syntax: =OCT2DEC(number) Situation: This formula is appropriate when you need to convert an octal...
Read More

OCT2BIN

  • May 31, 2023
Definition: OCT2BIN is a function that converts an octal number to a binary number. Syntax: =OCT2BIN(number, [places]) Situation: This formula is appropriate when you need to convert an...
Read More

NPV

  • May 31, 2023
Definition: NPV is a function that calculates the net present value of a series of cash flows. Syntax: =NPV(rate, value1, [value2], ...) Situation: This formula is appropriate when...
Read More

NPER

  • May 31, 2023
Definition: NPER is a function that calculates the number of payment periods for a loan or investment. Syntax: =NPER(rate, payment, present_value, [future_value], [type]) Situation: This formula is appropriate...
Read More

NOW

  • May 31, 2023
Definition: NOW is a function that returns the current date and time. Syntax: =NOW() Situation: This formula is appropriate when you need to get the current date and...
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

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

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

NORMINV

  • May 31, 2023
Definition: NORMINV is a function that returns the inverse of the normal distribution for a specified mean and standard deviation. Syntax: =NORMINV(probability, mean, standard_dev) Situation: This formula is...
Read More

NORMDIST

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