Page 277 - Excel Data Analysis

15 537547 AppC.qxd 3/4/03 11:56 AM Page 263

VBA AND EXCEL EVENTS QUICK REFERENCE C

VBA FUNCTION QUICK REFERENCE (CONTINUED)

Financial Functions (Continued)
FUNCTION DESCRIPTION RETURNS
IRR(values()[, guess]) Determines the internal rate of returns for a series Double
of cash flows.
MIRR(values(), finance_rate, reinvest_rate) Returns the modified interest rate of returns for Double
a series of periodic cash flows.
NPer(rate, pmt, pv[, fv[, type]]) Returns the number of periods for an annuity. Double
NPV(rate, values()) Returns the net present value of an investment. Double
Pmt(rate, nper, pv[, fv[, type]]) Returns the payment amount for an annuity based Double
on fixed payments.
PPmt(rate, per, nper, pv[, fv[, type]]) Returns the principal payment amount for an annuity. Double
PV(rate, nper, pmt[, fv[, type]]) Returns the present value of an annuity. Double
Rate(nper, pmt, pv[, fv[, type[, guess]]]) Returns the interest rate per period for an annuity. Double
SLN(cost, salvage, life) Determines the straight-line depreciation of an asset Double
for a single period.
SYD(cost, salvage, life, period) Determines the sum-of-years' digits depreciation of Double
an asset for a specified period.
Information Functions
FUNCTION DESCRIPTION RESULTS
CVErr(error number) Returns a user-defined error number. Variant
Error[(errornumber)] Returns the error message for the specified error number. String
IsArray(varname) Indicates whether a variable contains an array. Boolean
IsDate(expression) Indicates whether an expression contains a date. Boolean
IsEmpty(expression) Indicates whether a variable has been initialized. Boolean
IsError(expression) Indicates whether an expression is an error value. Boolean
IsMissing(argname) Indicates whether an optional argument was passed to a procedure. Boolean
IsNull(expression) Indicates whether an expression contains no valid data. Boolean
IsNumeric(expression) Indicates whether an expression is a number. Boolean
IsObject(identifier) Indicates whether a variable references an object. Boolean
TypeName(varname) Specifies the variable type. String
VarType(varname) Specifies the subtype of a variable. Integer

263