Filter
Top Products
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.