F

FACT function, 737

FACTDOUBLE function, 737

FALSE function, 735

FDIST function, 739

fields, 234

filenames, extracting from path specifications, 133

fill handle, 49

Filter command, 26, 249

filtering

clearing, 262-263

setting up criteria range, 260-262

specifying computed criteria, 269-270

specifying criteria, 263-270

specifying multiple criteria, 266-269

tables, 248-249

financial functions

bond calculations, 319-320

Excel's limitations with, 317-318

financial concepts, 296-297

future value, 302-305

interest and principal components, 312-314

interest rates, 314-316

payments, 305-306

periods, 309-311

present value, 298-302

rates, 306-309

financial schedules

amortization schedules, 348-354

basic financial statements, 362-366

creating, 347-348

creating indices, 369-371

loan options, summarizing using data table, 358-362

ratio analysis, 366-369

Find and Replace dialog box, 126, 543, 746

Find dialog box, 140

FIND function, 127-128, 132, 190, 742

Find What field, Find dialog box, 140

finding and searching within strings, 129-130

FINV function, 740

First Column check box, Tables menu, 244

first payment, timing of, 297

FISHER function, 740

FISHERINV function, 740

FIXED function, 742

Fixed-length strings data type, 653-654

floating-point number errors, 592-593

FLOOR function, 286, 288, 737

Format table gallery, 12

Font group, Home tab, 11-12

Font property, 674-675

Font tab, 12

FORECAST function, 390, 478, 740

Form controls, 23

Format Axis dialog box, 457

Format Cells dialog box, 12, 139, 144, 531, 748-749

Format Control dialog box, 463

Format Data Series dialog box, Series Options tab, 452-454, 457

Format Only Cells That Contain rule, 532, 541

Format Only Top or Bottom Ranked Values rule, 532

Format Only Unique or Duplicate Values rule, 532

Format Only Values That Are Above or Below Average rule, 532

Format Painter tool, Clipboard group, 11

Format Series dialog box, Series Option tab, 451

Format Trendline dialog box, 474, 479

Format Value Axis dialog box, 451, 453-454, 457

formatting. See also conditional formatting

dates and times, 145-147, 762-763

numeric, 22

pivot tables, 493-496

stylistic, 22

Formula Auditing group, 28

Formula AutoComplete feature, 72, 104, 627, 629

Formula AutoCorrect feature, 41

Formula Bar, 36

Formula box, 517

Formula Evaluator, 603-604

Formula property, 672

Formula tab, Options dialog box, 434

formula-based rules, 545-554

formulas. See also megaformulas

array formulas, 375-379

calculating, 44-45

cell and range references, 45-48

circular references, 53-55

converting to values, 49-51

for counting, 181-184

debugging. See debugging formulas

editing, 38-39

elements of, 34

entering, 34-35

entering worksheet functions into, 106-111

errors in, 52-53

goal seeking, 55-57

hiding, 51-52

limits, 37

making exact copy of, 48-49

overview, 23-24

pasting names into, 36

protecting from being overwritten, 30-31

returning errors, 585-589

sample formulas, 37

spaces and line breaks, 36

summing, 201-204

text formulas, 131-137

that are not calculated, 591

using operators in, 39-44

For-Next loops, 662-664

Fraction category, Format Cells dialog box, 759

Fraction number format, 18, 749

fractional dollars, 289-290

fractions, displaying, 759

Frankston, Bob, 2

frequency distribution, 122, 192-195

FREQUENCY function, 177, 192-196, 390, 740

FTEST function, 740

full-column or full-row as arguments, 103-104

function arguments, 100-101

Function Arguments dialog box, 106, 107-108, 631

Function Library group, Formulas tab, 106

functions. See also lookup functions; VBA custom function examples

arguments, 102-105, 629

categories of, 111-114

choosing name for, 627-628

creating add-ins, 641-643

custom, 551-554

custom, reasons for creating, 624

database functions, 271-273

date-related

calculating dates of holidays, 162-164

calculating number of days between dates, 153-154

calculating number of work days between dates, 154-155

calculating number of years between dates, 156

calculating person's age, 156-157

converting non-date string to date, 153

converting year to Roman numerals, 166

counting occurrences of day of week, 160-161

determining date of most recent Sunday, 159

determining date's quarter, 165

determining day of week, 158

determining day of year, 158

determining first day of week after date, 159

determining last day of month, 165

determining nth occurrence of day of week in month, 159-160

determining whether year is a leap year, 165

displaying any date, 151

displaying current date, 150

expressing date as ordinal number, 161-162

generating series of dates, 151-153

offsetting date using only work days, 155-156

declaring, 626-627

entering into formulas, 106-111

financial functions

bond calculations, 318-320

Excel's limitations with, 316-318

financial concepts, 296-297

future value, 302-305

interest and principal components, 311-314

interest rates, conversion formulas, 315-316

payments, 305-306

periods, 309-311

present value, 298-302

rates, 306-309

function procedures, 626-629

Insert Function dialog box, 630-633

mathematical, plotting, 463-468

multifunctional, 687-689

overview, 23-24, 99-102

performing otherwise impossible calculations, 100

providing decision-making capability, 101

reference for, 727-743

simplifying, 100

speeding up editing tasks, 100-101

testing and debugging

calling function from sub procedure, 637-640

setting breakpoint in functions, 640-641

using debug. print statements in code, 636-637

using VBA MsgBox statement, 634-636

text functions

changing case of text, 127-128

character codes, 118-120

counting characters in strings, 123-124

creating text histogram, 124-125

custom VBA functions, 137

determining whether cells contain text, 117-118

determining whether two strings are identical, 120-121

displaying formatted currency values as text, 123

displaying formatted values as text, 122-123

extracting characters from strings, 128

finding and searching within strings, 129-130

joining two or more cells, 121-122

padding numbers, 125-126

removing excess spaces and nonprinting characters, 126-127

repeating characters or strings, 124

replacing text with other text, 128-129

searching and replacing within strings, 130

time-related

adding hours, minutes, or seconds to a time, 172-173

calculating difference between two times, 170-171

converting between time zones, 173-174

converting decimal hours, minutes, or seconds to a time, 172

converting from military time, 171-172

displaying any time, 167-168

displaying current time, 166-167

rounding time values, 174-175

summing times exceeding 24 hours, 168-170

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

using in formulas, 628-629

using in named formulas, 86

VBA function example, 624-626

future value

calculating using NPV function, 330-331

of lump sum, 303-304

of payments, 302-303

of payments and lump sum, 304-305

Fv argument, 299-300

FV function, 732

FVSCHEDULE function, 316, 342-343, 732