E

early loan payoff, 310-311

EDATE function, 147, 729

Edit Custom Lists option, 523

Edit Formatting Rule dialog box, 541

Edit Links dialog box, 594, 643

Edit Name dialog box, 62

Edit toolbar, VB Editor, 648

EFFECT function, 315, 732

elements of formulas, 34

embedded charts, 8

Enable Automatic Percent Entry check box, Options dialog box, 746

Enable Background Error Checking, Formulas tab, 601

Enable Iterative Calculation check box, 432-436, 438, 442

Enable Iterative Calculation setting, 53

Encrypt Document dialog box, 30

engineering functions, 113

entering formulas, 34-35

EntireRow and EntireColumn properties, 675

EOMONTH function, 148, 729

equal sign (=), 33

Eqv operator, 655

ERF function, 730

ERFC function, 730

Error Alert tab, Data Validation dialog box, 557, 559

Error Checking dialog box, Formulas tab, 602-603

Error Checking Rules section, 601-602

Error Checking section, Formulas tab, 115

errors

# DIV/0! errors, 586-587

# N/A errors, 587

# NAME? errors, 587

# NULL! errors, 588

# NUM! errors, 588

# REF! errors, 588

# VALUE! errors, 589

in formulas, 52-53

names with, 78

returning error value, 711-712

ERROR.TYPE function, 734

Evaluate Formula dialog box, Formulas tab, 414, 603-604

EVEN function, 286, 290-291, 737

even integer, rounding to, 290-291

EXACT function, 118, 742

Excel versions, 3-7

Excel Function Library Group, 99

Excel Help system, 767

Excel newsgroups websites, 769-770

Excel Options button, 13

Excel Options dialog box, 13, 18, 55, 138

EXP function, 737

explicit intersection, 73

EXPONDIST function, 739

exponential trendlines, 479, 481-482

expressions, as arguments, 104-105

eXtensible Markup Language (XML), 5

external databases, 25

extra space characters, 585

extracting

all but first word of strings, 134-135

characters from strings, 128

filenames from path specifications, 133

first word of strings, 133-134

last word of strings, 134

names, 135-137