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

Excel Formulas

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

DCOUNTA

  • May 31, 2023
Definition: DCOUNTA is a function that counts the number of non-blank cells in a database that meet a specified condition. Syntax: =DCOUNTA(database, field, criteria) Situation: This formula is...
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

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

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

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

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

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

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

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