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