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

Month: May 2023

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

NETWORKDAYS

  • May 31, 2023
Definition: NETWORKDAYS is a function that calculates the number of working days between two given dates. Syntax: =NETWORKDAYS(start_date, end_date, [holidays]) Situation: This formula is appropriate when you need...
Read More

NEGBINOMDIST

  • May 31, 2023
Definition: NEGBINOMDIST is a function that returns the negative binomial distribution of a given set of data. Syntax: =NEGBINOMDIST(number_f, number_s, probability_s) Situation: This formula is appropriate when you...
Read More

NA

  • May 31, 2023
Definition: NA is a function that returns the error value #N/A, which indicates that a value is not available or not applicable. Syntax: =NA() Situation: This formula is...
Read More

N

  • May 31, 2023
Definition: N is a function that returns a value converted to a number. Syntax: =N(value) Situation: This formula is appropriate when you need to convert a value to...
Read More

MULTINOMIAL

  • May 31, 2023
Definition: MULTINOMIAL is a function that returns the factorial of a sum of values divided by the product of the factorials of the individual values. Syntax: =MULTINOMIAL(number1, [number2],...
Read More

MROUND

  • May 31, 2023
Definition: MROUND is a function that rounds a number to the nearest multiple of a specified value. Syntax: =MROUND(number, multiple) Situation: This formula is appropriate when you need...
Read More

MONTH

  • May 31, 2023
Definition: MONTH is a function that returns the month component of a given date. Syntax: =MONTH(serial_number) Situation: This formula is appropriate when you need to find the month...
Read More

MODE

  • May 31, 2023
Definition: MODE is a function that returns the most frequently occurring value in a range of cells. Syntax: =MODE(number1, [number2], ...) Situation: This formula is appropriate when you...
Read More

MOD

  • May 31, 2023
Definition: MOD is a function that returns the remainder of a division operation. Syntax: =MOD(number, divisor) Situation: This formula is appropriate when you need to find the remainder...
Read More