Table 9-3. Functions
That
Can Be Used in Formulas.
(Continued)
Function
Description
MAX(x:y) Compares x and
y,
and returns the larger
of
the two.
MIN(x:y) Compares x and
y,
and returns the smaller
of
the
two
.
MOD(x:y) The remainder
of
the division x / y. MOD(x,Y) = x - y x
INT(x:y)
PI
11"
;
3.14159265359
(12 digits).
RND(x:y) Rounds x
to
y decimal places, returns the rounded value.
SGN(x)
Sign
of
x (+ 1 if x > 0, 0 if x = 0, - 1 if x < o.
SPFV(i%:n) Future value
of
a single $1.00 payment; equivalent
to
(1
+
i%
-7-1
00) n. n
is
the number
of
compounding periods.
i%
is
the interest rate per compounding period, ex-
pressed
as
a percentage.
SPPV(i%:n) Present value
of
a single
$1.00
payment; equivalent
to
1
-7-
SPFV(i%:n). n
is
the number
of
compounding periods.
i%
is
the interest rate per compounding period, ex-
pressed
as
a percentage.
SQRT(x) Square root
of
x.
TRN(x:y) Truncates x
to
y decimal places, returns the truncated
value.
USFV(i%:n) Future value
of
a uniform series
of
$1
.
00
payments;
equivalent
to
(SPFV(i%:n)
-1)
-7-
(i%
-7-
100). n
is
the
number
of
payments.
i%
is
the periodic interest rate, ex-
pressed as a percentage.
USPV(i%:n) Present value
of
a uniform series
of
$1.00 payments;
equivalent
to
USFV(i%:n)
-7-
SPFV(i%:n). n is the number
of
payments.
i%
is
the periodic interest rate, expressed
as a percentage.
9:
The
Formula
Solver
145
To Next Page
Loading...
