Filter
Top Products
12: The Equation Solver 171
File name : English-M02-1-040308(Print).doc Print data : 2004/3/9
Table 12-2. Solver Functions for Equations (Continued)
Function Description
Σ(cfr:c
1
:c
2
:s:expr) Summation of the algebraic expression
expr for values of the counter ctr,
stepping from c
1
to c
2
at increments of s.
See page 176.
SIZEC(CFLO-listname) The number of the last flow in specified
CFLO list.
SIZES(SUM-listname) The number of items in specified SUM
list.
SPFV(i%:n)
Future value of a single $1.00 payment;
equivalent to (1 + i%
÷ 100)
n
. n is the
number of compounding periods. i% is
the interest rate per compounding
period, expressed as a percentage.
SPPV(i%:n)
Present value of a single $1.00
payment; equivalent to 1
÷ SPFV(i%:n).
n is the number of compounding
periods. i% is the interest rate per
compounding period, expressed as a
percentage.
SQ(x) Square of x ; x
2
.
SQRT(x)
Square root of x ;
X
.
#T(CFLO-listname:flow#)
The number of times that specified cash
flow occurs.
TRN(x:y)
Truncates
x to y decimal places if 0 ≤ y
≤11, or truncates x to y significant digits
if －12
≤ y ≤－1. y must be an integer.
USFV(i%:n)
Future value of a uniform series of
$1.00 payments; equivalent to
(SPFV(
i%:n)－1) ÷ (i% ÷100). n is
number of payments.
i% is periodic
interest rate, expressed as a
percentage.
USPV(i%:n)
Present value of a uniform series of
$1.00 payments; equivalent to
USFV(
i%:n) ÷ SPFV(i%:n). n is number of
payments.
i% is periodic interest rate,
expressed as a percentage.