Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

EUROCONVERT(number,source,target,full_precision,triangulation_

precision)

New in Excel XP - Converts a number to euros, converts a number from euros to

a euro member currency, or converts a number from one euro member currency

to another by using the euro as an intermediary (triangulation). The currencies

available for conversion are those of the European Union (EU) members that

have adopted the euro.

EVEN(number) [Category: Math]

Returns number rounded up to the nearest even integer. You can use this

function for processing items that come in twos. For example, a packing crate

accepts rows of one or two items. The crate is full when the number of items,

rounded up to the nearest two, matches the crate’s capacity. Guru Tip: I’ve been

waiting most of my Excel career to ﬁ nd a product that comes in crates of two so

that I can use this function. It has never happened yet. The book that you are

holding comes in crates of 24. Sigh.

EXACT(text1,text2) [Category: Text]

Compares two text strings and returns TRUE if they are exactly the same,

FALSE otherwise. EXACT is case-sensitive but ignores formatting differences.

Use EXACT to test text being entered into a document. Guru Tip: Excel will

generally ignore case of text. In the image below A1 and B1 are considered

equal. In the VLOOKUP in cell A4, the lower case "hello" is considered a match

for "HELLO". While this is mostly convenient, you might need to really know if

two cells have the exact same capitalization. In that case, use EXACT.

EXP(number) [Category: Math]

Returns raised to the power of number. The constant equals 2.71828182845904,

the base of the natural logarithm.

EXPONDIST(x,lambda,cumulative) [Category: Statistical]]

Returns the exponential distribution. Use EXPONDIST to model the time

between events, such as how long an automated bank teller takes to deliver