R


R1C1 notation, 45

R1C1 Reference Style option, 45

RADIANS function, 103, 110, 280, 464, 737

RAND function, 100, 111, 689-690, 738

RANDBETWEEN function, 691, 738

random names, generating, 578-579

random numbers, generating, 689-692

range operator, 74

Range property, 669-670

range references, 45-48

ranges

counting number of differences in, 407-408

counting number of error values in, 401-402

determining closest value in, 414

determining whether contains valid values, 409

determining whether particular value appears in, 406-407

displaying calendar in, 423-425

For Each-Next construct, 669

finding row of value's nth occurrence in, 408-409

Intersect function, 676-677

names of, 72-79

properties of, 672-676

randomizing, 716-717

referencing, 669-672

returning list of unique items in, 422-423

returning location of maximum value in, 408

returning longest text in, 409

returning nonblank cells from, 420

returning only positive values from, 419-420

reversing order of cells in, 420-421

Set keyword, 676

sorting range of values dynamically, 421-422

summing all cells in, 201-202

summing every nth value in, 412-413

summing n largest values in, 405

that contains errors, summing, 400-401

Union function, 677

UsedRange property, 677-678

words in, counting, 702

RANK function, 416-417, 741

Rate argument, 299, 301, 306, 308, 321, 344, 371

RATE function, 733

ratio analysis, 366-369

Recalculate Before Save option, 111

RECEIVED function, 733

Record Macro dialog box, 619

records, 234

rectangles, 282

recursive equation, solving, 437-438

Redo Delete button, 619

Redo tool, Quick Access toolbar (QAT), 14

reference functions, 112

reference operators, 38, 40

references, 545-546

References command, VB Editor's Tools, 628

referencing data, in tables, 255-259

Refers To field, 62, 79-80, 83, 86-87

Refresh, 489

Regional and Language Options, Windows Control Panel, 762

Regional Settings dialog box, Control Panel, 100

Regional Settings option, Windows Control Panel, 654

relative references, 545-546

problems with, 589-590

using named formulas with, 88-91

Remove All button, Subtotal dialog box, 275

Remove Arrows option, 599

Remove Duplicates dialog box, Tables menu, 244-245

Remove Errors option, 586

renaming

modules, in Visual Basic (VB) editor, 615

projects, in Visual Basic (VB) editor, 614

repeating character, filling cells with, 766

Replace Current Subtotals option, Subtotal dialog box, 275-276

REPLACE function, 127-128, 743

Report Filter section, 488, 496, 501-503

Report Layout option, 526

reports, producing with pivot tables, 524-526

REPT function, 122-123, 743

Require Variable Declaration option, VB Editor Options dialog box, 652

reserved words, 649

Reset Ignored Errors button, Formulas tab, 602

resources

help system, 767

Internet newsgroups, 769-771

Microsoft technical support, 768-769

web sites, 771-773

retirement, years until, 309-310

return on assets, 369

return on equity, 369

reversing strings, 695

Ribbon

contextual tabs, 14

galleries and live preview, 14

navigation, 13

number formatting using, 746-747

one-stop shopping, 12

screentips and dialog icons, 14

tabs, groups, and tools, 12-13

RIGHT function, 126, 151, 743

ROMAN function, 658-659, 738

Roman numerals, converting year to, 166

ROUND function, 172-173, 287, 304, 349, 412, 592-593, 738

ROUNDDOWN function, 287-288, 304, 738

rounding numbers, 286-291

rounding time values, 174-175

ROUNDUP function, 287-288, 304, 738

ROW function, 390, 410, 548, 736

Row labels, 490

rows

adding to tables, 241-242

deleting in tables, 242

displaying alternate-row shading, 547-548

duplicate, removing from tables, 244-245

groups of, shading, 548-549

naming, 68-69

returning last value in, 416

ROWS function, 111, 180, 736

RSQ function, 478, 741

R-squared, calculating, 478

RTD function, 736

Run Sub/UserForm option, VB Editor, 638

running total, 200

Runtime errors, 634




Excel 2007 Formulas
Excel 2007 Formulas (Mr. Spreadsheets Bookshelf)
ISBN: 0470044020
EAN: 2147483647
Year: 2007
Pages: 212

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net