Excel 2019 Bible

1037

Index

Symbols

! (exclamation point)

in link formula syntax, 638

when referencing cells in other workbooks, 224

when referencing cells in other worksheets, 223

“ (quote), in workbook filenames, 161

# (hash) marks

cells filled with, 50, 68, 425

in formula errors, 229

& (ampersand), entering in text, 189

& (concatenation) operator, 189, 208, 210, 225, 255

‘ (comment indicator), 936

() (parentheses)

nesting within formulas, 210–211

overriding Excel’s built-in precedence, 210–211

• (negation) operator, 430, 431


• (subtraction) operator, 208, 210, 431

  
  

  = (greater than or equal to) operator, 208
  (greater than) operator
  in condition arguments, 296
  as formula operator, 208, 210
  in workbook names, 161
  <= (less than or equal to), 208, 209
  < (less than) symbol
  as formula operator, 208, 210
  in workbook names, 161

  
  

  
  

• (aster isk)
  in condition arguments, 306
  searching for, 81
  in workbook names, 161
  in worksheet names, 57


• (multiplication) operator, 207, 208, 209, 211

• (addition) operator, 207, 208, 210


• (plus sign), in worksheet outlines, 634
  , (comma)
  in automatic number formatting, 46
  in function arguments, 213
  as list separator, 214
  as one-dimensional horizontal array list separator, 404
  as one-dimensional vertical array list separator, 405

as range reference operator, 214, 235

as two-dimensional horizontal array list separator, 405

• (minus sign), 634
  / (division) operator, 208, 209
  / (slash)
  in workbook names, 161
  in worksheet names, 56
  : (colon)
  in range addresses, 29, 71
  as range reference operator, 235
  in workbook names, 161
  in worksheet names, 56
  ; (semicolon)
  in custom number formats, 50
  as list separator, 214, 404
  in number formatting strings, 541, 542
  as two-dimensional vertical array list separator, 405
  when suppressing zeros, 543
  = (equal sign)
  as formula operator, 208, 209, 210, 214, 216
  in condition arguments, 296
  in named arrays, 407
  precedence, 210
  ? (question mark)
  in condition arguments, 306
  searching for, 81
  in workbook names, 161
  in worksheet names, 57
  [] (square brackets)
  in column names, 226, 229
  in link formula syntax, 638
  when applying custom format colors, 554
  in workbook names, 224
  in worksheet names, 56
  \ (backslash), in worksheet names, 56
  ^ (exponentiation) operator, 208, 209, 310
  {} (curly brackets)
  in array constants, 403, 407
  in array formulas, 408, 409
  in formula names, 401
  in named arrays, 407

Excel® 2019 Bible, First Edition. Michael Alexander, Dick Kusleika and John Walkenbach.
© 2019 John Wiley & Sons, Inc. Published 2019 by John Wiley & Sons, Inc.