Filter
Top Products
Functions and commands 345
Example:
SOLVE(X
2
-X-2,X,3)returns 2
This function also returns an integer that is indicative of the
type of solution found, as follows:
0—an exact solution was found
1—an approximate solution was found
2—an extremum was found that is as close to a solution
as possible
3—neither a solution, an approximation, nor an
extremum was found
See chapter 13, “Solve app”, beginning on page 257, for
more information about the types of solutions returned by this
function.
Spreadsheet functions
The spreadsheet functions can be selected from the App
Toolbox menu (
D > > Spreadsheet). They can
also be selected from the View menu (
V) when the
Spreadsheet app is open.
The syntax for many, but not all, the spreadsheet functions
follows this pattern:
functionName(input,[optional
parameters])
Input is the input list for the function. This can be a cell range
reference, a simple list or anything that results in a list of
values.
One useful optional parameter is Configuration. This is a
string that controls which values are output. Leaving the
parameter out produces the default output. The order of the
values can also be controlled by the order that they appear in
the string.