Share this Page URL

Table Formula > Table Formula - Pg. 295

Table Formula Table Figure 10-24. Constructing formulas that reference cells in a table Operators Common mathematical operators such as +, -, *, and /. Functions Special procedures provided by Word. Functions always appear outside parentheses. Ex- amples of common functions are SUM, which is used to add specified values together, AVERAGE, which calculates the average of specified values, and MIN, which calculates the smallest of any specified values. Enter the name of a function directly into the Formula box or choose a function from the Paste Function list. Choosing from the list enters the value in the Formula box at the insertion point. Values Simple numbers or the data in specific cells in a table. Values that are acted on by functions appear inside parentheses to the right of the function. For example, in the formula =SUM(5,8,9), the numbers five, eight, and nine are the values acted on by the SUM func- tion. A value can be more than just a number. It can also reference a specific cell in the active table or in any table in the document. Cells are typically referred to by their column and row position. Columns are lettered from left to right and rows are numbered from top to bottom. Thus, the cell in the third row of the third column would be C3. Note that cell references like this are always absolute. Inserting rows or columns later would mess up an existing formula. Cells can be referenced by themselves or as part of a range. The formula =SUM(B2,C3,C8) would calculate the sum of the three cells listed inside the parentheses. Reference a range of cells by separating the first and last cell with a colon. For example, the formula =SUM(B2:C8) would calculate the sum of all of the cells between B2 and C8. Note that the range can span both columns and rows. Cells in a range are read from left to right. In addition, Word stops the range calculation as soon as it encounters any blank cell, so make sure no cells in a range are blank before performing a calculation. Chapter 10:Table | 295