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

Blog

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

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

DGET

  • May 31, 2023
Definition: DGET is a function that extracts a single value from a database that meets a specified condition. Syntax: =DGET(database, field, criteria) Situation: This formula is suitable when...
Read More

DEVSQ

  • May 31, 2023
Definition: DEVSQ is a function that returns the sum of squares of deviations of data points from their mean. Syntax: =DEVSQ(number1, [number2], ...) Situation: This formula is suitable...
Read More

DELTA

  • May 31, 2023
Definition: DELTA is a function that compares two values and returns 1 if the values are equal, otherwise it returns 0. Syntax: =DELTA(value1, [value2]) Situation: This formula is...
Read More

DEGREES

  • May 31, 2023
Definition: DEGREES is a function that converts radians to degrees. Syntax: =DEGREES(angle) Situation: This formula is suitable when you need to convert an angle from radians to degrees....
Read More

DEC2OCT

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

DEC2HEX

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

DEC2BIN

  • May 31, 2023
Definition: DEC2BIN is a function that converts a decimal number to a binary number. Syntax: =DEC2BIN(number, [places]) Situation: This formula is suitable when you need to convert a...
Read More

DDB

  • May 31, 2023
Definition: DDB is a function that returns the depreciation of an asset for a specified period using the double-declining balance method. Syntax: =DDB(cost, salvage, life, period, [factor]) Situation:...
Read More