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

x Excel 2013 All-in-One For Dummies
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
Tracing precedents............................................................................ 349 Tracing dependents........................................................................... 352 Error checking.................................................................................... 353 Changing the Error Checking options.............................................355 Error tracing ....................................................................................... 356 Evaluating a formula.......................................................................... 358
Removing Errors from the Printout .......................................................... 360
Chapter 3: Date and Time Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . .361
Understanding Dates and Times ............................................................... 361 Changing the Regional date settings ............................................... 362 Building formulas that calculate elapsed dates.............................363 Building formulas that calculate elapsed times ............................. 363
Using Date Functions .................................................................................. 364 TODAY................................................................................................. 364 DATE and DATEVALUE ..................................................................... 365 DAY, WEEKDAY, MONTH, and YEAR .............................................. 366 DAYS360 .............................................................................................. 368 Other special Date functions............................................................368
Using Time Functions.................................................................................. 372 NOW..................................................................................................... 372 TIME and TIMEVALUE.......................................................................373 HOUR, MINUTE, and SECOND .......................................................... 374
Chapter 4: Financial Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .375
Financial Functions 101 .............................................................................. 375 The PV, NPV, and FV Functions.................................................................376 Calculating the Present Value .......................................................... 376 Calculating the Net Present Value ................................................... 377 Calculating the Future Value ............................................................ 378 The PMT Function ....................................................................................... 379 Depreciation Functions............................................................................... 383 Analysis ToolPak Financial Functions ...................................................... 385
Chapter 5: Math and Statistical Formulas . . . . . . . . . . . . . . . . . . . . . . .389
Math & Trig Functions ................................................................................ 390 Rounding off numbers.......................................................................390 POWER and SQRT..............................................................................394 The SUM of the parts......................................................................... 395 Conditional summing ........................................................................ 396