N function, 735
N/A for text, displaying, 759-760
NA function, 735
Name box, 58, 64-67
Name Lister utility, 68
Name Manager dialog box, 60-61, 64, 70, 76, 80-81, 83, 87, 92
Name Manager option, 256, 461, 594
Name property, 674
named cells, 81
named ranges, 81
names
advanced techniques that use names, 91-95
creating, 63-64
creating multisheet names, 71-72
deleting, 64
editing, 64
extracting, 135-137
Name Manager, 62-64
naming constants, 84-85
naming text constants, 85-86
overview, 60
pasting into formulas, 36
potential problems with, 80-83
of ranges and cells, 72-80
removing titles from, 137
scope of, 61-62
using cell and range references in named formulas, 87-88
using named formulas with relative references, 88-91
using worksheet functions in named formulas, 86
navigation, 13, 241
nearest multiple, rounding numbers to, 288
negative numbers, 291
negative sign, displaying on the right, 760-761
NEGBINOMDIST function, 741
nested parentheses, 40-41, 42-44
nesting functions, 102-103
net present value, 340-341
Net Profit Margin, 369
NETWORKDAYS function, 148, 152-153, 729
New Formatting Rule dialog box, 531, 533, 535-536, 538-539, 545-546
New Name dialog box, 61-64, 65-66, 85-86, 91, 382-383, 461-462
New Rule command, 529, 544
New Window option, 597
New Year's day, 163
newsgroups, 769-771
No Switch argument, 344
nodes, 614
NOMINAL function, 315-316, 733
Nominal rate, 314
nonblank cells, counting, 183
non-date string to date, converting, 153
None formula, 249
non-integers, 291
nonlinear trendlines, 479-483
non-numeric characters, removing from strings, 413-414
nonprinting characters, removing, 126-127
nontext cells, counting, 183
NORMDIST function, 741
NORMINV function, 741
NORMSDIST function, 741
NORMSINV function, 741
NOT function, 735
Not operator, 655
Novell company, 3
NOW function, 111, 121, 148, 164, 729
Nper argument, 299, 301, 309-311
NPER function, 733
NPV function
definition of NPV, 322-323
examples, 324-330
using to calculate accumulated amounts, 330-332
Number Format control, 143-144
Number format, Options dialog box, 748
number format string, 750-751
Number group, Home tab, 746-747
Number tab, Format Cells dialog box, 748-750, 753
NumberFormat property, 674
numbers
displaying text with, 763
expressing as ordinals, 132
formatting, 745-749. See also custom number formats
padding, 125-126
random, generating, 689-692
rounding, 286-291
spelling out, 700
numeric cells, counting, 183
numeric formatting, 20, 22
Numerical Count, 178