170 12: The Equation Solver
File name : English-M02-1-040308(Print).doc Print data : 2004/3/9
Table 12-2. Solver Functions for Equations (Continued)
Function Description
HMS(
time
)
Converts time in decimal hours to
HH.MMSS
format.
HRS(
time
)
Converts time in
HH.MMSS
format to
decimal hours.
IDIV(
x
:
y
)
Integer part of the quotient of x/y.
IF(
cond
:
expr
1
:
expr
2
)
Conditional expression: if cond is true, use
expr
1
; if cond is false, use expr
2
. See page
174.
INT(
x
)
Greatest integer less than or equal to
x
.
INV(
x
)
Inverse of x; 1/x.
IP(
x
)
Integer part of x.
ITEM(
SUM-listname:item#
)
Value of the specified SUM-list item.
L(x:
expr
)
Store the value of expr in the variable x.
The variable will not appear in the SOLVE
menu if it is only used in L and G functions.
This is useful if you have a complex
expression that uses the same sub
expression multiples times for example:
(1+i)^N x PV+((1–(1+i)^N)/(1–(1+i))) x PMT+FV
It can be written:
.
LN(
x
)
Natural (base e) log of x.
LNP1(
x
)
In (1 + x)
LOG(
x
)
Common (base 10) log of x.
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
)
Remainder of the division x/y. MOD(x,y) =
x
－
y x INT(x/y)
PI
π
; 3.14159265359 (12 digits).
RND(
x
:
y
)
Rounds
x
to
y
decimal places if 0
≤
y
≤
11,
or rounds
x
to
y
significant digits if
－
12
≤
y
≤
－
1.
y
must be an integer.
S(
variable name
)
Used in an IF function to test if
solving
for
the variable named. Used to combine
related equations into one Solver menu.
See page 178.
SGN(
x
)
Sign of
x
(
＋
1 if
x
>0, 0 if
x
＝
0,
－
1 if
x
<0.
