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

Excel Formulas

OCT2HEX

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

ODD

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

OFFSET

  • May 31, 2023
Definition: OFFSET is a function that returns a reference to a range that is offset from a starting cell reference. Syntax: =OFFSET(reference, rows, cols, [height], [width]) Situation: This...
Read More

PDURATION

  • May 31, 2023
Definition: PDURATION is a function that calculates the duration of an investment with a constant periodic payment and a constant interest rate. Syntax: =PDURATION(rate, payment, present_value, [future_value], [type])...
Read More

PEARSON

  • May 31, 2023
Definition: PEARSON is a function that returns the Pearson product-moment correlation coefficient between two sets of data. Syntax: =PEARSON(array1, array2) Situation: This formula is appropriate when you need...
Read More

NOMINAL

  • May 31, 2023
Definition: NOMINAL is a function that returns the annual nominal interest rate given the effective rate and the number of compounding periods per year. Syntax: =NOMINAL(effect_rate, npery) Situation:...
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

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

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

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