Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > D< Previous | Next > 

 ABC

D

EFGHIJKLMNOPQRSTUVWXYZ 
 
DATEThe serial number of a date given the year, month, day.
DATEDIF*The number of units between two dates.
DATEVALUEThe serial number that represents a given date in text format.
DAVERAGEThe average of values in a column satisfying a condition.
DAYThe day as an integer given a date serial number.
DAYS360The number of days between two dates, based on 30 day months.
DBThe depreciation of an asset (fixed-declining balance method).
DCOUNTThe total number of values in a column satisfying a condition.
DCOUNTAThe total number of non blank cells in a column satisfying a condition.
DDBThe depreciation of an asset (double-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.
DEGREESThe number of degrees given a number of radians.
DELTA*The numerical value indicating if two numbers are equal.
DEVSQThe sum of squares of deviations of data points from their sample mean.
DGETThe single value from a column satisfying a condition.
DISC*The discount rate for a security.
DMAXThe maximum value in a column satisfying a condition.
DMINThe minimum value in a column satisfying a condition.
DOLLARThe 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.
DPRODUCTThe product of values in a column satisfying a condition.
DSTDEVThe standard deviation of values in a column satisfying a condition.
DSTDEVPThe standard deviation of values in a column satisfying a condition.
DSUMThe sum of values in a column satisfying a condition.
DURATION*The annual duration of a security that pays interest periodically.
DVARThe variance from a database column that satisfies a condition.
DVARPThe variance from a database column that satisfies a condition.
 
 Note: * These are Analysis ToolPak functions

 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top