N

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