Brother International PDP350CJ Owner's Manual - English - Page 169
Editing the Spreadsheet, To insert a function by typing, To use a function within a function
View all Brother International PDP350CJ manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 169 highlights
For specific information about each argument, see Appendix A. You can embed one function within another. For example, to sum a range of values and get its integer value, you could type =INT(SUM(A3:A9)). When you embed one function within another, it is easy to lose track of where the parentheses belong. If you insert the function with placeholder arguments, Spreadsheet inserts the parentheses accurately. 5. Click on Paste. The function appears in the Edit Area. If you selected Paste Arguments, the arguments also appear in the Edit Area. 6. Click on Close to close the dialog box. 7. In the Edit Area, double-click the first argument to select it. 8. Type the text, value, formula or cell reference you want to use for the argument. Make sure you type it correctly. Your entry replaces the placeholder argument. 9. Continue replacing arguments as needed. 10. Click on the Enter button or press ENTER. 11. When the calculation is complete, the result appears in the spreadsheet. If the calculated result is not what you expect, be sure that you typed the formula correctly. 12. Click on Close to close the dialog box. "To insert a function by typing: 1. Select the cell where you want the result of the calculation to appear. 2. Type = to begin the formula. The equal sign appears in the Edit Area. 3. Type the function name. 4. Type the arguments, enclosed in parentheses. Be sure to include commas between arguments. 5. Click on the Enter button or press ENTER. When the calculation is complete, the result appears in the spreadsheet. "To use a function within a function: 1. Insert the first function. 2. In the Edit Area, select the argument you want to replace with a function. 3. Insert the second function. 4. Continue in this manner until the formula is complete. 5. Click on the Enter button or press ENTER. Editing the Spreadsheet After you have created a spreadsheet, you may want to make some changes. You may want to delete some obsolete information or to insert rows or columns to make room for new information. You may want to copy or move some information to a new location. Or you may simply need to correct an error you made. This section describes how to do the following: S Edit the contents of a cell S Copy and move information in a spreadsheet S Insert and remove rows and columns S Fill a range with a series of incremental values Spreadsheet 155