V

validation. See data validation

VALUE function, 410, 743

values

actual versus displayed, 591-592

coloring, 761-762

converting formulas to, 49-51

determining address of value within a range, 228

determining whether particular value appears in a range, 406-407

displaying total only when all entered, 549

error values in a range, counting, 184

formatted, displaying as text, 122-123

literal, as arguments, 104

logical, counting, 184

looking up by using closest match, 229-230

looking up exact value, 219-220

looking up using linear interpolation, 230-232

looking up value to the left, 220-221

n largest, summing in ranges, 405

non… time-of-day values, 175-176

returning last value in rows and columns, 414-416

rounded, summing, 411-412

rounding time values, 174-175

scaling, 755-758

summing based on a date comparison, 207-208

summing based on a different range, 207

summing based on a text comparison, 207

valid, determining whether range contains, 409

Values area, 490, 516

values argument, SERIES formula, 445

Var formula, Tables menu, 250

VAR function, 687, 742

VARA function, 742

Variable-length strings data type, 653-654

variables, 650-652

Variant (with characters) data type, 650

Variant (with numbers) data type, 650

VARP function, 742

VARPA function, 742

Vary Colors by Point option, 452

VB Editor window, 611-612, 619

VBA (Visual Basic for Applications)

arrays, 656-657

built-in VBA functions, 657-659

comments, 648

constants, 652-653

controlling execution

On Error statement, 667-668

If-Then construct, 659-661

looping blocks of instructions, 662-666

Select Case construct, 661-662

custom functions, 137. See also VBA custom function examples

data types, 649-650

dates, 654

displaying Developer tab, 608

example function procedure, 646-648

macro security, 609-610

overview, 607-608

ranges

For Each-Next construct, 669

Intersect function, 676-677

referencing, 669-672

Set keyword, 676

Union function, 677

UsedRange property, 677-678

useful properties of, 672-676

saving workbooks that contain macros, 610-611

assignment expressions, 654-656

strings, 653-654

variables, 650-652

VB editor

activating, 611

code windows, 613, 616-618

entering VBA code, 618-621

Immediate window, 613

menu bar, 612

Project window, 612, 613-616

Properties window, 613

saving projects, 621

toolbars, 612

VBA custom function examples

advanced function techniques

randomizing a range, 716-717

returning array from a function, 712-713

returning array of nonduplicated random integers, 714-715

returning error value, 711-712

using indefinite number of arguments, 719-723

using optional arguments, 718-719

counting, 701-703

dates, 703-706

determining cell's data type, 685-686

generating random numbers, 689-692

multifunctional functions, 687-689

multisheet functions, 708-710

returning last nonempty cell in column or row, 706-708

sales commissions calculation, 692-695

simple functions, 680-685

text manipulation, 695-700

VBA MsgBox statement, 634-636

VDB function, 344, 345-346, 734

version of Excel, 5-7, 683

Veterans Day, 164

View Side by Side command, 597

VisiCalc, 2, 4

VLOOKUP function, 110, 211-215, 220-221, 223, 229, 355-356, 736

volatile functions, 111

volume

of cones, 284

of cubes, 283

of cylinders, 284

of pyramids, 284

of spheres, 283