AppleWorks Spreadsheet: A Guide for Island Teachers
Entering a Formula into a Spreadsheet Parts of a Formula The building blocks of a formula are: equal sign: = the equal sign lets AppleWorks spreadsheet know that you are enter ing a formula and not numbers or text. Always begin a formula with an = sign. operators: +, -, *, /, etc. The operators are symbols that represent a mathemati cal operation to be performed. For example, a forward slash (/) indicates division, while a greater than sign (>) compares two values.     B4,C5 add     B4+C5 add     C5...C9 add all cells from the first through the last     B3*G3 multiply     C5/G6 divide     D7-G12 subtract     (B1+B5)*C3, parentheses indicate order of operations functions: the functions are predefined, named formulas provided by AppleWorks. For example, the SUM function produces a total for a range of cells. A function is written like this: = to indicate it is a formula, SUM tells CW what function to perform, (inside parentheses type the range of the cells, eg. B1..B10): =SUM(B1..B10) other examples: =SUM(A3...H3) will add the entries in row 3 from column A to column H =SUM(B5...B23) will add the entries in column B from row 5 to row 23 =SUM(D12,H14)/B4 will add D12 and H14 and then divide the sum by the value in B4 =SUM(A1, D3, D4, D5, F6, G12, H20) will add these scattered cells together. previous page || page 1 || next page Technology Integration Document P.E.I. Department of Education, 2000 Operators: + addition - subtraction * multiplication / division