Excel Notes:

Formula Copying:

IF Function:

  1. Ask a question where the answer is Yes or No
    1. examples:
      1. H4="yes"
      2. H3 < 7
      3. H5 >6 AND H3 < 12
  2. If answer is YES do ...... (top box)
  3. If answer is NO do ..... (bottom box)

vlookup (vertical lookup)

Payment: