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

Blog

DVAR

  • May 31, 2023
Definition: DVAR is a function that returns the variance of a population based on a database that meets a specified condition. Syntax: =DVAR(database, field, criteria) Situation: This formula...
Read More

DURATION

  • May 31, 2023
Definition: DURATION is a function that returns the Macaulay duration of a security, which is a measure of the security's interest rate risk. Syntax: =DURATION(settlement, maturity, coupon, yld,...
Read More

DSUM

  • May 31, 2023
Definition: DSUM is a function that sums the values in a database that meet a specified condition. Syntax: =DSUM(database, field, criteria) Situation: This formula is suitable when you...
Read More

DSTDEVP

  • May 31, 2023
Definition: DSTDEVP is a function that returns the standard deviation of a population based on an entire database. Syntax: =DSTDEVP(database, field) Situation: This formula is suitable when you...
Read More

DSTDEV

  • May 31, 2023
Definition: DSTDEV is a function that returns the standard deviation of a population based on a database that meets a specified condition. Syntax: =DSTDEV(database, field, criteria) Situation: This...
Read More

DPRODUCT

  • May 31, 2023
Definition: DPRODUCT is a function that multiplies the values in a database that meet a specified condition. Syntax: =DPRODUCT(database, field, criteria) Situation: This formula is suitable when you...
Read More

DOLLARFR

  • May 31, 2023
Definition: DOLLARFR is a function that converts a fractional value to text with a currency format based on a specified fraction. Syntax: =DOLLARFR(fraction, [decimals]) Situation: This formula is...
Read More

DOLLARDE

  • May 31, 2023
Definition: DOLLARDE is a function that converts a decimal number to text with a currency format based on a specified fraction. Syntax: =DOLLARDE(fractional_value, [decimals]) Situation: This formula is...
Read More

DOLLAR

  • May 31, 2023
Definition: DOLLAR is a function that converts a number to text with a currency format. Syntax: =DOLLAR(number, [decimals]) Situation: This formula is suitable when you need to convert...
Read More

DMIN

  • May 31, 2023
Definition: DMIN is a function that returns the minimum value in a database that meets a specified condition. Syntax: =DMIN(database, field, criteria) Situation: This formula is suitable when...
Read More