Page 316 - Excel 2013 All-in-One For Dummies

Contents at a Glance
Chapter 1: Building Basic Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . .299
Formulas 101 ................................................................................................ 300 Copying Formulas........................................................................................ 312 Adding Array Formulas...............................................................................319 Range Names in Formulas .......................................................................... 323 Adding Linking Formulas............................................................................333 Controlling Formula Recalculation............................................................ 334 Circular References ..................................................................................... 336
Chapter 2: Logical Functions and Error Trapping . . . . . . . . . . . . . . . . .339
Understanding Error Values....................................................................... 339 Using Logical Functions..............................................................................341 Error-Trapping Formulas............................................................................342 Whiting-Out Errors with Conditional Formatting....................................346 Formula Auditing ......................................................................................... 347 Removing Errors from the Printout .......................................................... 360
Chapter 3: Date and Time Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . .361
Understanding Dates and Times ............................................................... 361 Using Date Functions .................................................................................. 364 Using Time Functions.................................................................................. 372
Chapter 4: Financial Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .375
Financial Functions 101 .............................................................................. 375 The PV, NPV, and FV Functions.................................................................376 The PMT Function ....................................................................................... 379 Depreciation Functions............................................................................... 383 Analysis ToolPak Financial Functions ...................................................... 385
Chapter 5: Math and Statistical Formulas . . . . . . . . . . . . . . . . . . . . . . .389
Math & Trig Functions ................................................................................ 390 Statistical Functions....................................................................................399
Chapter 6: Lookup, Information, and Text Formulas . . . . . . . . . . . . . .409
Lookup and Reference ................................................................................ 409 Information, Please . . ................................................................................. 420 Much Ado about Text ................................................................................. 424