|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