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

Excel Formulas

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

FDIST

  • May 31, 2023
Definition: FDIST is a function that returns the F probability distribution for a specified set of parameters. Syntax: =FDIST(x, degrees_freedom1, degrees_freedom2) Situation: This formula is suitable when you...
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

FIND

  • May 31, 2023
Definition: FIND is a function that searches for a specified text string within another text string, and returns the starting position of the first occurrence. Syntax: =FIND(find_text, within_text,...
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

FINDB

  • May 31, 2023
Definition: FINDB is a function that searches for a specified text string within another text string, and returns the starting position of the first occurrence, counting each double-byte...
Read More

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

DVARP

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

EDATE

  • May 31, 2023
Definition: EDATE is a function that returns the serial number of the date that is a specified number of months before or after a specified date. Syntax: =EDATE(start_date,...
Read More

EFFECT

  • May 31, 2023
Definition: EFFECT is a function that returns the effective annual interest rate based on a nominal interest rate and the number of compounding periods per year. Syntax: =EFFECT(nominal_rate,...
Read More