Alphabetical - D
DATE | The date as a date serial number given a year, month, day. |
DATEDIF | (Compatibility) The number of days, months or years between two dates. |
DATEVALUE | The date serial number given a date in text format. |
DAVERAGE | The arithmetic mean of all the numbers in a column that satisfies multiple conditions. |
DAY | The day as an integer given a date serial number. |
DAYS | The number of days between two dates. |
DAYS360 | The number of days between two dates, based on 30 day months. |
DB | The depreciation of an asset in a single period (declining balance method). |
DBCS | (Japanese) The text string converted from single byte to double byte characters. |
DCOUNT | The number of numerical values in a column that satisfies multiple conditions. |
DCOUNTA | The number of numerical values in a column that satisfies multiple conditions (including logical values and text). |
DDB | The depreciation of an asset in a single period (double or triple declining balance method). |
DEC2BIN | The number converted from decimal to binary. |
DEC2HEX | The number converted from decimal to hexadecimal. |
DEC2OCT | The number converted from decimal to octal. |
DECIMAL | The decimal number of a text representation of a number in a given base. |
DEGREES | The number of degrees given a number of radians. |
DELTA | The numerical value indicating if two numbers are equal. |
DETECTLANGUAGE | (365) Preview. The language code for the text string provided. |
DEVSQ | The sum of the squared deviations from the mean. |
DGET | The single value in a column that satisfies multiple conditions. |
DISC | The interest rate (or discount rate) for a security held to maturity. |
DMAX | The largest value in a column that satisfies multiple conditions. |
DMIN | The smallest value in a column that satisfies multiple conditions. |
DOLLAR | The text string of a number with the dollar formatting $0,000.00. |
DOLLARDE | The dollar fraction expressed as a decimal. |
DOLLARFR | The dollar decimal expressed as a fraction. |
DPRODUCT | The product of the values in a column that satisfies multiple conditions. |
DROP | (2024) The array without certain rows or columns. |
DSTDEV | The standard deviation of the values in a column that satisfies multiple conditions based on a sample. |
DSTDEVP | The standard deviation of the values in a column that satisfies multiple conditions based on an entire population. |
DSUM | The total of the values in a column that satisfies multiple conditions. |
DURATION | The annual duration of a security that pays interest periodically. |
DVAR | The variance of the values in a column that satisfies multiple conditions based on a sample. |
DVARP | The variance of the values in a column that satisfies multiple conditions based on an entire population. |
DATE The date as a date serial number given a year, month, day. |
DATEDIF (Compatibility) The number of days, months or years between two dates. |
DATEVALUE The date serial number given a date in text format. |
DAVERAGE The arithmetic mean of all the numbers in a column that satisfies multiple conditions. |
DAY The day as an integer given a date serial number. |
DAYS The number of days between two dates. |
DAYS360 The number of days between two dates, based on 30 day months. |
DB The depreciation of an asset in a single period (declining balance method). |
DBCS (Japanese) The text string converted from single byte to double byte characters. |
DCOUNT The number of numerical values in a column that satisfies multiple conditions. |
DCOUNTA The number of numerical values in a column that satisfies multiple conditions (including logical values and text). |
DDB The depreciation of an asset in a single period (double or triple declining balance method). |
DEC2BIN The number converted from decimal to binary. |
DEC2HEX The number converted from decimal to hexadecimal. |
DEC2OCT The number converted from decimal to octal. |
DECIMAL The decimal number of a text representation of a number in a given base. |
DEGREES The number of degrees given a number of radians. |
DELTA The numerical value indicating if two numbers are equal. |
DETECTLANGUAGE (365) Preview. The language code for the text string provided. |
DEVSQ The sum of the squared deviations from the mean. |
DGET The single value in a column that satisfies multiple conditions. |
DISC The interest rate (or discount rate) for a security held to maturity. |
DMAX The largest value in a column that satisfies multiple conditions. |
DMIN The smallest value in a column that satisfies multiple conditions. |
DOLLAR The text string of a number with the dollar formatting $0,000.00. |
DOLLARDE The dollar fraction expressed as a decimal. |
DOLLARFR The dollar decimal expressed as a fraction. |
DPRODUCT The product of the values in a column that satisfies multiple conditions. |
DROP (2024) The array without certain rows or columns. |
DSTDEV The standard deviation of the values in a column that satisfies multiple conditions based on a sample. |
DSTDEVP The standard deviation of the values in a column that satisfies multiple conditions based on an entire population. |
DSUM The total of the values in a column that satisfies multiple conditions. |
DURATION The annual duration of a security that pays interest periodically. |
DVAR The variance of the values in a column that satisfies multiple conditions based on a sample. |
DVARP The variance of the values in a column that satisfies multiple conditions based on an entire population. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top