SOLVER Functions
Table 9-3 lists
the
functions
that
can
be
included
in formulas. Lower-
case characters in
parentheses
stand
for
numbers,
variable
names,
or
numeric
expressions.
Table 9-3. Functions
That
Can Be Used in Formulas.
Function
Description
ABS(x) Absolute value
of
x.
ALOG(x) Common (base 10) antilogarithm;
10X
DATE(d1
:n)
The date n days after (when n
is
positive)
or
before
(when
n
is
negative) date d1. The format for
d1
is
set
in
the TIME/SET menu.
DDAYS(d1:d2:c) The number
of
days between dates
d1
and d2. The for-
mats for
d1
and
d2
are set
in
the TIME menu; c
designates the calendar:
EXP(x)
EXPM1(x)
FACT(x)
FP(x)
IDIV(x:y)
INT(x)
IP(x)
LN(x)
LNP1(x)
LOG
• c = 1 for the actual calendar, which recognizes leap
years.
• c = 2 for the 365-day calendar, which ignores leap
years.
• c = 3
for
the 360-day calendar, which uses 12, 30-day
months.
Natural antilogarithm;
eX
eX
-1
x!; factorial
of
a positive integer
Fractional part
of
x.
Integer
part
of
the quotient
of
x / y.
The greatest integer less than
or
equal
to
x.
Integer
part
of
x.
Natural (base
e)
log
of
x.
In
(1
+
x)
Common (base 10) log
of
x.
144
9:
The
Formula
Solver
To Next Page
Loading...
