L

LARGE function, 291

syntax, 26

learning curve, 378.

See also power curves

industry estimates for, 381

modeling, 379–381

origin of, 381

least-squares line, 369

LEFT function, 30, 33

left-hand lookups, 147

LEN function, 31, 33

linear models in Excel Solver, 226–227

linear pricing, 563

linear relationships. See correlations;

straight-line relationships

LINEST function, 394

linking

cells, 99

consolidated data, to source data, 358

lists

averaging numbers that are greater or equal to median, 577

matching text in, identifying, 576

subtotals in. See subtotals

lists of valid entries, limiting data entry to, 272

loans

amount to borrow, determining, 120–121

interest rate, determining. See RATE function

interest, determining between two periods. See CUMIPMT function

payments, calculating, 60–62

payments, calculating for variable interest rate, 247–249

periods necessary to pay back, determining, 64

principal, determining between two periods. See CUMPRINC function

principal, determining monthly amount paid towards, 61–62

LOGEST function, 582–584

lookup functions.

See also HLOOKUP function;

VLOOKUP function

defined, 11

when first column is non-numeric, 13–14

lookup range, naming, 13

for price that changes by date, 14–15

on right-most column in table range, 147

lookup range, 23

loops. See circular references

LOWER function, 32

lowercase, changing text to, 32