Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
DEC2OCT(number,places) [Category: Engineering]*
Converts a decimal number to octal. Guru Tip: Since each character in the
result holds 3 bits (2^3), the 10 character result can hold up to 29 bits plus a
sign bit as the most signifi cant bit. The result is that DEC2OCT can work with
positive numbers up to 536,870,911 and negative numbers (expressed in two’s
complement notation) to -536,870,912. If the places argument is omitted, Excel
will return only as many characters as necessary.
DEGREES(angle) [Category: Math]
Converts radians into degrees. Guru Tip: Cosine and sine functions in Excel
work with radians instead of degrees. There are 2 x Pi radians in a circle and
360 degrees in a circle. You can convert radians to degrees by dividing the
radians by (PI()/180) or instead use this handy function.
DELTA(number1,number2) [Category: Engineering]*
Tests whether two values are equal. Returns 1 if number1 = number2; returns 0
otherwise. Use this function to fi lter a set of values. For example, by summing
several DELTA functions you calculate the count of equal pairs. This function is
also known as the Kronecker Delta function.
DEVSQ(number1,number2,...) [Category: Statistical]]
Returns the sum of squares of deviations of data points from their sample
mean.
DGET(database,fi eld,criteria) [Category: Database]
Extracts a single value from a column in a list or database that matches conditions
you specify. Guru Tip: Please read and understand DSUM fi rst. This is the one
unique function amongst the database functions. It will return a single value at
 
Search JabSto ::




Custom Search