Filter
Top Products
Programming 551
More
%CHANGE Syntax: %CHANGE(x,y)
The percentage change in going from x to y.
Example: %CHANGE(20,50) returns 150.
%TOTAL Syntax: %TOTAL(x,y)
The percentage of x that is y.
Example: %TOTAL(20,50) returns 250.
CAS Syntax: CAS(Exp.) or CAS.function(...) or
CAS.variable[(...)]
Evaluates the expression or variable using the CAS.
EVALLIST Syntax: EVALLIST({list})
Evaluates the content of each element in a list and returns
an evaluated list.
EXECON Creates a new list based on the elements in one or more
lists by iteratively modifying each element according to an
expression that contains the ampersand character (&). The
syntax:
EXECON(expression with &,list
1
[list
2
] …
[list
n
])
Where the expression is & plus an operator (o) plus a
number (n), each element in the list is operated on by o
and n and a new list created.
Examples:
EXECON("&+1",{1,2,3}) returns {2,3,4}
Where the & is followed directly by a number, the position
in the list is indicated. For example:
EXECON("&2–&1",{1, 4, 3, 5}" returns {3, –1,
2}
In the example above, &2 indicates the second element
and &1 the first element in each pair of elements. The
minus operator between them subtracts the first from the
second in each pair until there are no more pairs. Note
that numbers appended to & can only be from 1 to 9
inclusive.