Brother International PDP350CJ Owner's Manual - English - Page 183

Using Advanced Spreadsheet Formulas This section assumes you are familiar with the information covered in Getting Started. This section describes how to create formulas and use functions to make complex formulas easy. This section explains how to do the following: S Show and hide formulas S Assign names to cells and ranges so you can use the names in formulas S Turn automatic recalculation on and off S Use circular references and iteration in calculations S Use advanced functions Showing and Hiding Formulas In order to see a formula for a single cell, you can select the cell and look at the formula in the Edit Bar. If you want, you can display all of the formulas in the spreadsheet cells. This can be helpful if you have entered several formulas and want to see them all at once. When you show all formulas, formulas appear in cells as if they were labels. That is, if a formula is too long for a cell, it may spill over into the next cell if that cell is empty. If the adjacent cell is not empty, the formula appears cut off. "To show or hide all formulas: 1. Select Other Settings from the Options menu. A submenu appears. 2. Select Show Formulas to show all formulas. OR Deselect Show Formulas to hide all formulas. Naming Cells and Ranges When you create a formula, you normally include references to the cells and ranges you want to use in the calculation. While you can refer to cells and ranges by their addresses, you can also name a cell or a range and then use the name in formulas. This can make your formulas easier to read. The second formula in the following example is much easier to understand than the first. B4=B2+B3 or INCOME=SALARY+TIPS An absolute reference tells Spreadsheet the specific address of a cell. A relative reference tells Spreadsheet how to find a particular cell starting from the cell containing the formula, such as: "go two rows up and one column to the right." Cell names can be up to 40 characters long and can include alphanumeric characters and the underscore (_) symbol. Cell names cannot contain numbers, spaces, or other characters. If you type a space, Spreadsheet inserts an underscore. Cells names are case insensitive; for example, to Spreadsheet, the name Expenses" is the same as EXPENSES" and expenses." Spreadsheet 169