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, ...

Get Excel Formulas & Functions For Dummies, 5th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.