Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
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