Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
the intersection of many criteria. In the fi gure for DSUM, the formula in cell J18
is =DGET($A$3:$D$15,"Revenue",F18:H19) and will fi nd the single cell which
matches all three criteria.
DISC(settlement,maturity,pr,redemption,basis) [Category: Financial]*
Returns the discount rate for a security.
DMAX(database,fi eld,criteria) [Category: Database]
Returns the largest number in a column in a list or database that matches
conditions you specify. Guru Tip: See DSUM.
DMIN(database,fi eld,criteria) [Category: Database]
Returns the smallest number in a column in a list or database that matches
conditions you specify. Guru Tip: See DSUM.
DOLLAR(number,decimals) [Category: Text]
Converts a number to text using currency format, with the decimals rounded to
the specifi ed place. The format used is $#,##0.00_);($#,##0.00).
DOLLARDE(fractional_dollar,fraction) [Category: Financial]*
Converts a dollar price expressed as a fraction into a dollar price expressed as
a decimal number. Use DOLLARDE to convert fractional dollar numbers, such
as securities prices, to decimal numbers. Guru Tip: This function is pretty much
obsolete since Wall Street switched to decimal prices for stock quotes in 2001.
DOLLARFR(decimal_dollar,fraction) [Category: Financial]*
Converts a dollar price expressed as a decimal number into a dollar price
expressed as a fraction. Use DOLLARFR to convert decimal numbers to
fractional dollar numbers, such as securities prices.
DPRODUCT(database,fi eld,criteria) [Category: Database]
Multiplies the values in a column in a list or database that match conditions that
you specify. Guru Tip: See DSUM.
DSTDEV(database,fi eld,criteria) [Category: Database]
Estimates the standard deviation of a population based on a sample, using the
numbers in a column in a list or database that match conditions that you specify.
Guru Tip: See DSUM.
DSTDEVP(database,fi eld,criteria) [Category: Database]
Calculates the standard deviation of a population based on the entire population,
using the numbers in a column in a list or database that match conditions that
you specify. Guru Tip: See DSUM.
DSUM(database,fi eld,criteria) [Category: Database]
Adds the numbers in a column in a list or database that match conditions that
you specify. Guru Tip: Before pivot tables, most analysts made frequent use
of DSUM and the similar database functions such as DAVERAGE, DCOUNT,
 
Search JabSto ::




Custom Search