Spreadsheets: Functions and Formulae

Spreadsheets: Functions and Formulae

1. CONCATENATE

   • Page 256
     • Links things together in a chain or series
       • Example: =CONCATENATE(!!,!!) will return the things with no space between them; =CONCATENATE(!!," ",!!) will return it with a space between them

2. LEFT

   • Page 256
     • Returns with the specified number of characters, starting from the very most left character of the string
       • Example: =LEFT(!!,1) will extract the left most character; =LEFT(!!,2) will return with the first and second characters of the string

3. RIGHT

   • Page 256
     • Returns with the specified number of characters, starting with the very most right character of the string
       • Example: =RIGHT(!!,1) will extract the right most character; =RIGHT(!!,2) will return with the first and second characters from the right

4. MID

   • Page 256
     • Returns with the specified number of characters, starting from the middle of the string
       • Example: =MID(!!,3,1) will extract only one character, starting from the third character; =MID(!!,3,4) will extract 4 characters starting from the third characters

5. LEN

   • Will count the number of characters in the string

6. SUM

   • Will count the content of cells over a range
     • Example: =SUM(!!:!!) will add the content of all cells in that range

7. Formula

   • You can do quick maths with *, -, + and /.

8. ROUND

   • Page 260
     • Rounds the content of a cell to a specified number of characters
       • Example: =ROUND(!!,1) will round the cell to one decimal place; =ROUND(!!,0) will round the cell to the integer value; =ROUND(!!,-1) will round the cell to the nearest 10.

9. AVERAGE

   • Page 261
     • Calculates the average from a list of numbers
       • Example: =AVERAGE(!!:!!) will calculate the average from the range

10. MAX

    • Page 262
      • calculates the maximum from a range
        • Example: =MAX(!!,!!) will calculate the maximum from that range

11. MIN

    • Page 262
      • Calculates the minimum from a range
        • Example: =MIN(!!:!!) will calculate the minimum from the range

12. COUNTA

    • Page 226
      • Counts the number of cells in a range that are not empty