Excel Formulas & Functions For Dummies, 5th Edition

Index

Symbols

• * (asterisk), 196
• {} (braces), 56–57
• $ (dollar sign), 349
• ("") (empty string), 319
• = (equal sign), 19
• > (greater than), 334
• >= (greater than or equal to), 334
• < (less than), 334
• <= (less than or equal to), 334
• ? (question mark), 196

A

• ABS function, 135–136
• absolute addressing, 23
• absolute deviations, 171
• ABSOLUTE (ABS) function, 134
• absolute reference, 270, 349
• accelerated depreciation schedule, 106–107, 109–112
• Accounting format, 86–88
• active cell, 1
• Add Watch dialog box, 78–79
• addition, 26, 346
• address
  • cell, 14
  • range, 15
• address argument, 290
• ADDRESS function, 270–274
• Alexander, Michael (author)
  • Excel VBA Programming For Dummies, 5th Edition, 357
• analyzing
  • data with percentiles and bins, 183–194
  • deviations, 170–172
• AND function, 267–269, 333–334
• appreciation. See also depreciation
  • about, 103–104
  • FV function, 92, 103, 104–106
  • IRR function, 114–118
• arguments
  • address, 290
  • for CELL function, 290–291
  • col, 290
  • color, 290
  • contents, 290
  • defined, 37
  • directory, 294
  • filename, 290
  • format, 290, 292–293
  • for functions, 29–32
  • Numfile, 294
  • origin, 294
  • osversion, 294
  • parentheses, 290
  • prefix, 290
  • protect, 291
  • recalc, 294
  • release, 294
  • row, 291
  • selecting functions that take no, 41–42
  • selecting functions that use, 42–43
  • system, 294
  • type, 291
  • values for SUBTOTAL function, 149–151
  • width, 291
• arrays
  • about, 55–57
  • functions that return, 61–64
  • using in formulas, 57–60
• assembling formulas, 25–27
• asterisk (*), 196
• auditing formulas, 75–78
• Automatic Calculation, 69
• AutoSum, ...