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

"To use iteration: 1. Choose Calculation from the Options menu. The dialog box at the left appears. 2. Fill in the dialog box, specifying the options you want. S Allow Iterations. Select the Allow Iteration option if you are going to use iteration in your spreadsheet. S Maximum Iterations. Enter the maximum number of iterations you want. S Maximum Change. Enter the maximum change you want to allow. 3. Click on Apply. 4. Click on Close. The dialog box disappears. 5. Create the formula with a circular reference. Spreadsheetrecalculatesthe formula the specified number of times or stops when the stated value for maximum change is calculated. Advanced Functions This section describes how to use more complex functions that involve the following capabilities: S Conditional statements S Text strings S Arrays S Lookup See the Appendix for brief descriptions of the functions organized by function type and an alphabetical listing of functions with a complete description and syntax for each. Spreadsheet includes the following types of functions: strings, time and date, financial, math, statistical, trigonometric, information, logical, and print. Named cells and ranges are particularly useful as arguments for functions. For more information on how to name ranges, see "Naming Cells and Ranges" on page 169. You can use a list of values, separated by commas and enclosed in parentheses as arguments for many functions. If the function uses a list for its arguments, each item in the list is evaluated. For example, the following two functions are equivalent: SUM(A1:A4) SUM(A1,A2,A3,A4) Working with strings See the Appendix for a list of string functions. String functions let you perform operations on text in spreadsheet cells. The text in a spreadsheet cell is called a text string. At least one argument in each string function is a text string. String functions extract text (including numbers) or return values based on the text. For example, you can use RIGHT to extract the last four digits of a stock number that might identify the manufacturer of a product. Spreadsheet 174