More Functions

• Last section we looked at financial functions
• We pick up statistical functions, If and vlookup in this section
• We learn how to sort a column of data.
• Statistical Functions
  • average
  • sum
  • min
  • max
  • count
  • counta
• In general functions are preferable to algebra expressions
  • =a1+a2+a3
  • =sum(a1:a3)
  • functions automatically adjust when rows/columns are inserted/deleted
  • They are less prone to error (fewer keystrokes if nothing else)
• if
  • =if(condition,true value, false value)
  • =if(b4>90,"A","B")

  • Operator	Description
    =	equal to
    <>	not equal to
    <	less than
    >	greater than
    <=	less than or equal to
    >=	greater than or equal to

• Hlookup and vlookup
  • vlookup(value to look up, range_start: range_end, column with return n value
  • hlookup is horizontal, vlookup is vertical