L

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