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

Excel Formulas

DISC

  • May 31, 2023
Definition: DISC is a function that returns the discount rate for a security. Syntax: =DISC(settlement, maturity, pr, redemption, [basis]) Situation: This formula is suitable when you need to...
Read More

DMAX

  • May 31, 2023
Definition: DMAX is a function that returns the maximum value in a database that meets a specified condition. Syntax: =DMAX(database, field, criteria) Situation: This formula is suitable when...
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

DAY

  • May 31, 2023
Definition: DAY is a function that returns the day of the month for a specified date. Syntax: =DAY(date) Situation: This formula is suitable when you need to retrieve...
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

COUNTIF

  • May 31, 2023
Definition: COUNTIF is a function that counts the number of cells in a range that meet a specified condition. Syntax: =COUNTIF(range, criteria) Situation: This formula is suitable when...
Read More

COUNTIFS

  • May 31, 2023
Definition: COUNTIFS is a function that counts the number of cells in a range that meet multiple specified conditions. Syntax: =COUNTIFS(range1, criteria1, [range2], [criteria2], ...) Situation: This formula...
Read More

COVAR

  • May 31, 2023
Definition: COVAR is a function that returns the covariance between two sets of data. Syntax: =COVAR(array1, array2) Situation: This formula is suitable when you need to find the...
Read More

CRITBINOM

  • May 31, 2023
Definition: CRITBINOM is a function that returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. Syntax: =CRITBINOM(trials, probability_s,...
Read More

CUBEKPIMEMBER

  • May 31, 2023
Definition: CUBEKPIMEMBER is a function that returns a key performance indicator (KPI) value from an online analytical processing (OLAP) cube. Syntax: =CUBEKPIMEMBER(connection, kpi_name, [kpi_property], [member_expression]) Situation: This formula...
Read More