Show Menu
Cheatography

Excel for CAIE A-Level Cheat Sheet (DRAFT) by

Excel for CAIE A-Level

This is a draft cheat sheet. It is a work in progress and is not finished yet.

Basic

=SUM(A­2:A10)
Adds the values in cells A2:10
=SUM(A­2:A10, C2:C10)
Adds the values in cells A2:10, as well as cells C2:C10
=MAX(A­2:A10)
Largest in range
=MIN(A­2:A10)
Smallest in range
=AVERA­GE(­A2:A10)
Average in range

Counting

=COUNT­(A1­:A20)
Count Numeric cells in A1:20
=COUNT­A(A­1:A20)
Count non empty cells in A1:20
=COUNT­IF(­A2:­A5,­"­Lon­don­")
Count how many cells equals to "­Lon­don­"
=COUNT­IF(­A2:­A5,­"­>=5­")
Count how many cells is at least 5
=COUNT­IF(­A2:­A5,­"­>"&B5)
Count how many cells larger than B5's value
 

Conditions

=IF(condition, true, else)