Brother Ensemble PDP-100J, Руководство пользователя

Страница: 188 / 440

Spreadsheet 174
"
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
maximumchange 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.
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
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 eachstring 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.
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.
See the Appendix for a list of
string functions.