Labor Day, 163
LARGE function, 100, 201-202, 405, 421, 740
Last Column check box, Tables menu, 244
LASTINCOLUMN function, 707
LASTINROW function, 707-708
late payment table, amortization schedules, 354-355
Layout group option, 495
LCM function, 737
leading dots, displaying, 766
leap year bug, 147-148
LEFT function, 85, 102, 126, 131-132, 151, 670, 718, 742
LEN function, 121, 392, 410, 743
letter grades, determining for test scores, 223-224
Life argument, 344
Line with Markers option, Chart Tools, 459
linear equations, 284-285
linear interpolation, looking up values using, 230-232
linear trendlines, 475-478
LINEST function, 390, 476, 740
link formulas, 46
linked picture objects, 25
links to cells, creating, 448-449
liquidity ratios, 366-368
List Formulas option, 523
List option, Settings tab, 557
List Separator setting, 100
literal argument, 102
literal values, as arguments, 104
live preview, 12, 14
LN function, 737
loan options, summarizing using data table, 358-362
loan rates, 307-308
loans, interest-free, 309
Lock Project for Viewing checkbox, VB Editor, 642
LOG function, 737
LOG10 function, 737
logarithmic trendlines, 479-480
LOGEST function, 390, 740
Logical errors, 582, 634
logical functions, 112-113
logical values, 184, 594-595
LOGINV function, 740
LOGNORMDIST function, 740
Long data type, 650
lookup formula, 211
LOOKUP function, 213, 216-217, 221, 224, 232, 736
lookup functions
calculating grade point average, 224-225
case-sensitive lookup, 221-222
choosing among multiple lookup tables, 222-223
combining MATCH and INDEX functions, 217-218
determining address of value within a range, 228
determining letter grades for test scores, 223-224
HLOOKUP function, 215
looking up a value using linear interpolation, 230-232
looking up exact value, 219-220
looking up value by using closest match, 229-230
looking up value to the left, 220-221
LOOKUP function, 216-217
overview, 211-213
two-column lookup, 227-228
two-way lookup, 225-227
VLOOKUP function, 213-215
Lookup Wizard add-in, 226
looping blocks of instructions, 662-666
Lotus, 2, 4, 76, 101, 145, 263
Lotus Compatibility Settings section, 76
LOWER function, 125, 743
lump sum, future value of, 303-304