Alphabetical - D

DATEThe date as a date serial number given a year, month, day.
DATEDIF(Compatibility) The number of days, months or years between two dates.
DATEVALUEThe date serial number given a date in text format.
DAVERAGEThe arithmetic mean of all the numbers in a column that satisfies multiple conditions.
DAYThe day as an integer given a date serial number.
DAYSThe number of days between two dates.
DAYS360The number of days between two dates, based on 30 day months.
DBThe depreciation of an asset in a single period (declining balance method).
DBCS(Japanese) The text string converted from single byte to double byte characters.
DCOUNTThe number of numerical values in a column that satisfies multiple conditions.
DCOUNTAThe number of numerical values in a column that satisfies multiple conditions (including logical values and text).
DDBThe depreciation of an asset in a single period (double or triple declining balance method).
DEC2BINThe number converted from decimal to binary.
DEC2HEXThe number converted from decimal to hexadecimal.
DEC2OCTThe number converted from decimal to octal.
DECIMALThe decimal number of a text representation of a number in a given base.
DEGREESThe number of degrees given a number of radians.
DELTAThe numerical value indicating if two numbers are equal.
DETECTLANGUAGE(365) Preview. The language code for the text string provided.
DEVSQThe sum of the squared deviations from the mean.
DGETThe single value in a column that satisfies multiple conditions.
DISCThe interest rate (or discount rate) for a security held to maturity.
DMAXThe largest value in a column that satisfies multiple conditions.
DMINThe smallest value in a column that satisfies multiple conditions.
DOLLARThe text string of a number with the dollar formatting $0,000.00.
DOLLARDEThe dollar fraction expressed as a decimal.
DOLLARFRThe dollar decimal expressed as a fraction.
DPRODUCTThe product of the values in a column that satisfies multiple conditions.
DROP(2024) The array without certain rows or columns.
DSTDEVThe standard deviation of the values in a column that satisfies multiple conditions based on a sample.
DSTDEVPThe standard deviation of the values in a column that satisfies multiple conditions based on an entire population.
DSUMThe total of the values in a column that satisfies multiple conditions.
DURATIONThe annual duration of a security that pays interest periodically.
DVARThe variance of the values in a column that satisfies multiple conditions based on a sample.
DVARPThe 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