Excel

Excel Formulas Notes | PDF

Also read Skills for Success Excel Chapter 1 Skills 1, 3, 4, 6, 7 and Excel Chapter 2 Skill 2

• formulas and cell references
  • =A1
  • =A1 * 0.5
  • =A1 + B2 * B3 / C4
  • =(A1 + B2) * (B3 / C4)
• the SUM function
  • right: =SUM(A1, A2, A3, A4)
  • right: =SUM(A1:A4)
  • right: =A1 + A2 + A3 + A4
  • wrong: =(A1,A2,A3,A4)
  • wrong: =(A1:A4)
  • stupid: =SUM(A1 + A2 + A2 + A4)
  • also stupid:  =SUM(B1 * B2)
  • also stupid: = SUM(B1)
• show formulas (CTRL+~)   (~ is at top left corner of keyboard)

• relative references change when formulas are copied or filled
• absolute references do not change
  • absolute references have $ in front of parts that should not change, e.g. $A$1 -- change neither row nor column.
• charts
• if function
  • =IF(condition_to_check, value_if_true, value_if_false)
  • =IF(B2 > 10, "B2 over 10", "B2 not over 10")