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

IDIV(x:y)

decimal hours.

Integer part of the quotient of x/y.

IF(cond:expr1:expr2)

Conditional expression: if cond is true, use

 

expr1; if cond is false, use expr2. 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.

170 12: The Equation Solver

File name : English-M02-1-040308(Print).doc Print data : 2004/3/9