Excel 2007 Formulas (Mr. Spreadsheets Bookshelf)

Macro dialog box, 631

Macro Name box, 631

Macro Options dialog box, 631

Macro Security option, 609

macro sheets, 10-11

macros, 26, 610-611

Madison, Josh, 279

Manage Rules command, 529, 542

Manual Recalculation mode, 111

Manual setting, Calculation mode, 42

Martin Luther King, Jr. Day, 163

MATCH function, 213, 217-218, 221, 226, 409, 571-572, 736

math trigonometry functions, 112

mathematical functions, plotting, 464-468

Maturity, bond properties, 318

Max formula, Tables menu, 250

MAX function, 98, 401, 409, 664, 687, 740

MAXA function, 740

maximizing windows, in VB editor, 616-617

Maximum Change field, 53

Maximum iterations, 53, 434, 437, 442

McRitchie, David, 773

MDETERM function, 737

MDURATION function, 733

MEDIAN function, 687, 740

megaformulas

examples

determining validity of credit card number, 574-578

generating random names, 578-579

removing middle names, 567-570

returning string's last space character position, 570-574

simple example, 564-566

overview, 563-564

pros and cons of, 580

Memorial Day, 163

menu bar, Visual Basic (VB) editor, 612

Merge & Center command, 238, 424

Microsoft, 5

Microsoft Knowledge Base website, 768

Microsoft news server website, 769

Microsoft newsgroups website, 769

Microsoft Office Online website, 19

Microsoft SharePoint service, 238

Microsoft technical support, 768-769

MID function, 110, 126, 151, 410, 572, 647, 743

military time, converting from, 171-172

millions, displaying values in, 756-757

MIN function, 401, 408, 452, 687, 740

MINA function, 740

Mini Toolbar, 10, 14

minimizing windows, in VB editor, 616-617

MINUTE function, 164, 729

minutes, 172-173

MINVERSE function, 390, 737

MIRR function, 316, 336-340, 733

mismatched parentheses, 583-584

mixed references, 43-47, 88-89, 158, 200, 589

MMULT function, 390, 737

MOD function, 412-413, 460, 548, 655, 737

MODE function, 188, 687, 741

modifying pivot tables, 496-498

money. See financial functions

month

determining last day of, 165

determining nth occurrence of day of week in, 159-160

MONTH function, 84, 148, 158, 729

More functions option, Table menu, 250

More Number Formats option, Number Format control, 144

Most Recently Used category, 105

Moving Average option, Chart Tools, 479

Mr. Excel web site, 773

MROUND function, 286, 288, 737

MS-DOS, 3

multicell array formulas

creating array constant from values in a range, 386-387

creating array from values in a range, 386

displaying calendar in a range, 423-425

generating an array of consecutive integers, 390-391

performing operations on an array, 387-388

returning list of unique items in a range, 422-423

returning nonblank cells from a range, 420

returning only positive values from a range, 419-420

reversing order of cells in a range, 420-421

sorting range of values dynamically, 421-422

transposing an array, 389-390

using functions with an array, 389

multidimensional arrays, declaring, 657

multifunctional functions, 687-689

MULTINOMIAL function, 737

Multiplan, 3

multiple lookup tables, choosing among, 222-223

multisheet functions, 708-710

multisheet names, creating, 71-72

My Power Utility Pak, 25