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 signiﬁ 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 ﬁ 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,ﬁ 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 ﬁ rst. This is the one

unique function amongst the database functions. It will return a single value at