Excel 2007 Formulas (Mr. Spreadsheets Bookshelf)

icon sets, 538-542

Icon Sets command, 529, 538, 541

identity operations, 394

IF function, 99, 393-395, 401-403, 408-409, 412-413

IFERROR function, 130-132, 355-356, 420-422, 568-570

If-Then construct, 659-661

Ignore Blank check box, Settings tab, 557

Ignore Error option, 602

Ignore Relative/Absolute check box, 75

illustrations, 24

IMABS function, 731

IMAGINARY function, 731

IMARGUMENT function, 731

IMCONJUGATE function, 731

IMCOS function, 731

IMDIV function, 731

IMEXP function, 731

IMLN function, 731

IMLOG10 function, 731

IMLOG2 function, 731

Immediate window, VB Editor, 613, 632, 636-638

Imp operator, 655

implicit intersections, 73-74

IMPOWER function, 731

IMPRODUCT function, 731

IMREAL function, 731

IMSIN function, 731

IMSQRT function, 731

IMSUB function, 731

IMSUM function, 731

income statement, 362, 365

Incomplete calculation errors, 583

inconsistent date entries, 148-149

incorrect reference errors, 582

Increase Decimal button, 747, 753

indefinite number of arguments, 719-723

Independence Day, 163

INDEX function, 74, 108, 217-218, 221, 226, 409, 736

indices, creating, 369-371

indirect cell precedents, 599

indirect circular references, 431

INDIRECT function, 89-93, 111, 230, 391, 410, 736

INFO function, 734

information functions, 113

Insert Calculated Field dialog box, 515

Insert Function dialog box, 107-109, 630-633

Insert tab, Ribbon component, 10-11

inserting rows or columns, 80

INT function, 286, 290, 737

Integer data type, 650

integers, summing digits of, 410-411

INTERCEPT function, 740

interest, 312-316, 354-356

interest-free loans, 309

internal rate of return, 341-342

Internet features, 27

Internet newsgroups. See newsgroups

interpolation, 230-232

Intersect function, 676-677

INTRATE function, 732

INVALIDPART function, 554

IPMT function, 312-313, 732

IRR function, 332-336

irregular cash flows, 340-342

ISBLANK function, 734

ISERR function, 182, 401, 734

ISERROR function, 182, 401, 685, 734

ISEVEN function, 734

ISLOGICAL function, 685, 734

ISMISSING function, 718

ISNA function, 182, 401, 409, 734

ISNONTEXT function, 181, 712, 734

ISNUMBER function, 734

ISODD function, 734

ISPMT function, 733

ISREF function, 734

ISTEXT function, 111, 115, 685, 698-699, 735

iteration, animating charts using, 441-442