Google Spreadsheet Formulas: Not Just for Numbers

Introduction:

While this area of this site will provide some information about various formulas and functions, the meat of this session will be done using a shared Google Spreadsheet workbook. You do not need to be logged in to your Google account to use the shared sheet

The workbook has two worksheets. 
  • The first sheet can be edited by anyone. Enter information and you will be able to view that data being used in formulas on the second sheet.
  • The second sheet is protected and can only be viewed. It may need to be REFRESHED in order for changes made on the the first sheet to become visible on the second sheet.

The Structure of Formulas:

Here is some basic information for those of you unfamiliar with spreadsheets and/or the use of formulas. 

Cells are labeled with a letter and a number representing the column and row respectively. 

For example, A3 would refer to the cell located in the first column (A) and on the third row (3).


A3


You can add a formula to any cell in a spreadsheet by typing an equal sign (=) followed by the name of the function and a set of parentheses containing the information needed to calculate the formula result. Auto-suggest will show a box displaying the name and syntax of the formula you're building. 

Auto Suggest and Syntax

Here is a page listing good functions with which to start and what the rest of this session will cover.

Here is a list of all the functions for Google Spreadsheets.