User Manual

Page 4-124 Windows CE
Max(number, number, ...) Returns the maximum value in the list of
arguments.
Example: Max(1, 2, 3) equals 3.
Min(number, number, ...) Returns the minimum value in the list of
arguments.
Example: Min(1, 2, 3) equals 1.
Permut(number, numberChosen) Returns the number of permutations.
Number is the number of objects, numberChosen is the number of objects in
each permutation.
Example: Permut(10, 2) equals 90.
Stdev(number, number, ...) Estimates the standard deviation based on a
sample.
StdevP(number, number, ...) Calculates the standard deviation of the
entire population.
Var(number, number, ...) Estimates the variance based on a sample.
VarP(number, number, ...) Calculates the variance of the entire population.
Financial Functions
Ddb(cost, salvage, life, period, factor) Returns the depreciation of an
asset for a specified period using the double-declining balance
method (you can specify another method). Cost is the initial cost of
the asset. Salvage is the value at the end of the depreciation. Life is the
number of periods over which the asset is being depreciated. Period is
the period for which you want to calculate the depreciation. Period
must use the same units as life. Factor is the rate at which the balance
declines. If factor is omitted, it is assumed to be 2. All the arguments
must be positive numbers.
Example: Ddb(30000, 500, 3650, 10) equals 16.357.
Fv(rate, nper, pmt, pv, type) Returns the future value of an investment.
Rate is the interest rate per period. Nper is the total number of payment
periods in an annuity. Pmt is the payment made each period. Pv is the
present value. Type can be 0 or 1 (0 - payments at the end of the period, 1 - at
the beginning). If type is omitted, it is assumed to be 0.
Example: Fv(0.01, 12, -500) equals 6341.25.
IPmt(rate, per, nper, pv, fv, type) Returns the interest payment for an
investment. Per is the period for which you want to find the interest (must be
1 <= per <= nper). For more information see Pmt.
Example: Ipmt(0.01, 1, 24, 5000) equals -50.