To learn about array formulas, see “Working with Arrays,” p. 85.
To learn about the #DIV/0! error, see “#DIV/0!,” p. 108.
For a general discussion of function syntax, see “The Structure of a Function,” p. 126.
For the details on the REPT() function, see “The REPT() Function: Repeating a Character,” p. 143.
To learn about extracting a name from a string, see “Extracting a First Name or Last Name,” p. 148.
For the details of the CHOOSE() function, see “The CHOOSE() Function,” p. 183.
To learn how to use the WORKDAY() function, see “A Workday Alternative: The WORKDAY() Function,” p. 208.
To learn how to apply ledger shading automatically, see “Creating Ledger Shading,” p. 243.