Chapter 2 of Excel, Part 2. Logic and Financial Functions

• Some Notes
  • Have a couple of Timbits. I have 80 for this class.
  • From APSCUF: Thank you for all of the food. Everything left over was donated to the Edinboro Food Bank in the name of the Students of Edinboro University.
  • We do not know a make up schedule, it will need to be worked out and will be announced.
    • But time will be made up.
    • I will adjust the class schedule as this becomes available.
    • I am going to declare "Friday" is the new "Monday" for the short term
    • Let's work out long term problems when we know what is happening.
  • I have moved most due dates by a proportion of time they were from 10/19
    • Everything has at least two business days.
    • Talk to me if you have a problem (NOW, not in December)
  • I have graded all homework and make up that I could
    • For spreadsheets, if you don't use computations they are worth 0 points.
    • You don't need to wrap basic formulas in a function =sum(a3*b3) would be better as =a3*b3
• Let's quickly do something close to the receipt exercise.
• New Material
  • Payment function
    • =pmt(rate, payments, amount due)
    • The rate is a periodic rate.
      • Normally it is monthly
      • But there are other loan options.
      • Divide the annual rate by the number of payments.
      • normally 12.
    • payments are the number of payments
      • Normally the number of months.
      • Multiply the years by payments per year
      • Normally multiply by 12.
    • The amount due is how much you borrow.
      • This is the principal
      • Or the cost minus any down payments
      • Normally make this negative.
    • Do several loans.
  • If statements.
    • If statements allow us to make simple decisions in a spreadsheet
    • =if(yes no question, yes computation, no computation)
    • The yes no question
      • Six comparisons (=, <>, <, <=, >, >=)
    • The yes and no computations are anything
      • Just words, but in quotation marks.
      • =if(b3 > 0, "Positive", "Negative")
      • A computation
      • =if(a6 = "Taxable", a5*$a$3, a5)
    • Let's start with this workbook.
    • First compute a price discount amount.
      • If the price is above a given amount, they receive a high discount.
      • Otherwise a normal discount.
      • Just look up the discount percent.
    • Second let's compute the member discount.
      • If they are a member, apply this discount as well.
      • Just compute the discount, don't record discount amount.
    • Finally, our owner will send a think you note if the final amount is above a listed minimum.
      • Put a "Yes" in this field for anyone who gets a letter.
      • And put "No" otherwise.