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