home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Big Blue Disk 43
/
bbd43.zip
/
PCFUNREF.TXT
< prev
next >
Wrap
Text File
|
1990-03-19
|
4KB
|
61 lines
|A╔═══════════════╗══════════════════════════════════════════════╔═══════════════╗
|A║ |6Personal Calc|A ║══════════ ^1Function Reference Sheet |A══════════║ |6Personal Calc|A ║
|A╚═══════════════╝══════════════════════════════════════════════╚═══════════════╝
^Cby
^CDoug Harrison
* Arithmetic * * Financial *
DIV(numerator, denominator) integer PV(rate, # periods, pmt, future
result of division value, type) present value
MOD(numerator, denominator) remainder FV(rate, # periods, pmt, present
of division (modulus) value, type) future value
ABS(expr) absolute value NPER(rate, payment, present value,
* Exponential * future value, type) # periods
LN(expr) natural log (base e) PMT(rate, # periods, present val,
LOG(expr) log base 10 future val, type) payment
EXP(expr) e to a power RATE(# periods, pmt., present val,
POW(expr1,expr2) expr1 to expr2 power future val, type, guess) rate
SQR(expr) square * Lookup *
SQRT(expr) square root INDEX(row index, col index, range)
* Trigonometric * VLOOKUP(lookup, col index,range)
SIN(angle) sine HLOOKUP(lookup, row index, range)
COS(angle) cosine CHOOSE(index, expr1, expr2,...)
TAN(angle) tangent LOOKUP(lookup value, lookup range,
ASIN(expr) arc sine results range)
ACOS(expr) arc cosine MATCH(lookup value, range, type)
ATAN(expr) arc tangent * Date/Time *
ATAN2(x-expr,y-expr) 4-quad arc tan DATE(year, month, day) yields date
RAD(angle degrees) degrees to radians number (integer)
DEG(angle radians) radians to degrees YEAR(expr) year of date number
PI() pi MONTH(expr) month of date number
* Logical * DAY(expr) day of date number
= <> < <= > >= logical operators WEEKDAY(expr) day of week of date
IF(condition, action, alternate number (1=Sun)
action) if-then-else ISLEAP(expr) 1 if leap year
AND(expr1, expr2, expr3,...) AND DAYSMONTH(month, year) days in mo.
OR(expr1, expr2, expr3,...) OR TIME(hours, minutes, seconds) time
NOT(expr) NOT number (fraction)
TRUE() 1 HOUR(expr) hour of time number
FALSE() 0 MINUTE(expr) minute of time number
* Statistical * SECOND(expr) second of time number
SUM(expr list) sum NOW() current date and time
PROD(expr list) product * Cell *
MEAN(expr list) mean ROW(cell ref) row number
MEDIAN(expr list) median COLUMN(cell ref) column number
VAR(expr list) sample variance * Range *
VARP(expr list) population variance ROWS(range) no. of rows in range
SDEV(expr list) sample std. deviation COLUMNS(range) no. of columns in
SDEVP(expr list) population std. range
deviation * Miscellaneous *
SERR(expr list) std. deviation of ISERR(expr list) 1 if error
mean (the std. error) ISNA(expr list) 1 if NA
MAX(expr list) maximum ISEMPTY(list of cells or ranges) 1
MIN(expr list) minimum if all cells are empty
COUNT(expr list) count cells ERROR() set error condition on
containing values ROUND(expr, place) round
RAND(lower bound, upper bound) random TRUNC(expr, place) truncate
number INT(expr) integer portion
FRAC(expr) fractional portion