5.5数据类型检查与 转换函数 1. Asc(string) 10. IsMissing(argname) 2.类型转换 11.IsNull(expression) 3. Choose(index, choice-1L 12. IsNumeric(expression) choice-2 L, choice-n]])13. IsObject(identifier) 4. Chr(charcode) 5. f(expr, truepart 14. Partition(number, start, stop, interval) falsepart) 15. Str(number) 6. IsArray (varname) 16. Switch(expr-1, value-1L, expr-2 7. IsDate(expression) value-2L, expr-n, value-nI 8. IsEmptylexpression) 17. Type Name(varname) 9. IsError(expression) 18. Val(string) 19. VarType(varname) 单
6．IsArray(varname) 5 . 5 数据类型检查与 转换函数 7．IsDate(expression) 8．IsEmpty(expression) 9．IsError(expression) 10．IsMissing(argname) 11．IsNull(expression) 1．Asc(string) 2．类型转换 3．Choose(index, choice-1[, choice-2, ... [, choice-n]]) 4．Chr(charcode) 5．IIf(expr, truepart, falsepart) 12．IsNumeric(expression) 13．IsObject(identifier) 14．Partition(number, start, stop, interval) 15．Str(number) 16．Switch(expr-1, value-1[, expr-2, value-2 _ [, expr-n,value-n]]) 17．TypeName(varname) 18．Val(string) 19．VarType(varname)
5.6文件操作函数 1. CurDir[(drive) 7. FreeFilet(rangenumber)] 2. DirI(pathname, attributes])] 8. GetAttr(pathname 3. EOF(filenumber) 9. Loc(filenumber) 4. FileAttr(filenumber, returntype) 5. File Date Time(pathname) 10. LOF(filenumber) 6. FileLen(pathname) 11. Seek(filenumber) 单②
5 . 6 文件操作函数 1．CurDir[(drive)] 2．Dir[(pathname[, attributes])] 3．EOF(filenumber) 4．FileAttr(filenumber, returntype) 5．FileDateTime(pathname) 6．FileLen(pathname) 7．FreeFile[(rangenumber)] 8．GetAttr(pathname) 9．Loc(filenumber) 11．Seek(filenumber) 10．LOF(filenumber)
5.7输入输出函数 1.Input(number, f]filenumber) 2. InputBox(promptl, title [, default L xpos]I, ypos]L, helpfile, context]) 3. MsgBox(promptL, buttons L, title][, helpfile, context]) 4. Spc(n) 5. Tab[(n)] 返国金单②
5 . 7 输入输出函数 1．Input(number, [#]filenumber) 2．InputBox(prompt[, title] [, default] [, xpos] [, ypos] [, helpfile, context]) 3．MsgBox(prompt[, buttons] [, title] [, helpfile, context]) 4．Spc(n) 5．Tab[(n)]
5.8财会类函数 1.pB(cost, salvage, NPV(rate, values() life, period[, factorl) 8. Pmt(rate, nper, p v, fv, typel 2. FV(rate, nper, pmt, pvl, type]l) 3. Pmt(rate, per, nper, 9. PPmt(rate, per, nper, pvL, fvl, type]l pvI, fvt, type] 4. IRR(ValuesOl, guess])10. PV(rate, nper, pmt[, fvf, typel) 5. MIRR(values, finance rate 11. Rate(nper, pmt, pV reinvest rate) L, fvi, type, guess]] 6. NPer(rate, pmt, 12. SLN(cost, salvage, life) pvL, fv, typel) 13. SYD(cost, salvage, life, period 返国金单②
5 . 8 财会类函数 1．DDB(cost, salvage, life, period[, factor]) 2．FV(rate, nper, pmt[, pv[, type]]) 3．IPmt(rate, per, nper, pv[, fv[, type]]) 4．IRR(values()[, guess]) 5．MIRR(values(), finance_rate, reinvest_rate) 6．NPer(rate, pmt, pv[, fv[, type]]) 7．NPV(rate, values()) 8．Pmt(rate, nper, pv[, fv[, type]]) 9．PPmt(rate, per, nper, pv[, fv[, type]]) 10．PV(rate, nper, pmt[, fv[, type]]) 11．Rate(nper, pmt, pv [, fv[, type[, guess]]]) 12．SLN(cost, salvage, life) 13．SYD(cost, salvage, life, period)
5.9格式化数据 Format(expression, format, firstdayofweekl, firstweekofyear]]) 2. FormatCurrency( Expression LNumDigits AfterDecima GIncludeLeadingDigitL, UseParensForNegativeNumbers [ GroupDigits]] 3. FormatDateTime(DateL, NamedFormat]) 4. FormatNumber(Expression GNumDigits AfterDecimalL, IncludeLeadingDigit L UseParensForNegativeNumbers[ GroupDigits]1) 5. FormatPercent(ExpressionLN umDigitsAfterDecimal GIncludeLeadingDigit l, UseParensForNegative Numbers L GroupDigits]l1) 返国金单②
5 . 9 格式化数据 1．Format(expression[, format[, firstdayofweek[, firstweekofyear]]]) 2．FormatCurrency(Expression [,NumDigitsAfterDecimal [,IncludeLeadingDigit[, UseParensForNegativeNumbers [,GroupDigits]]]]) 3．FormatDateTime(Date[,NamedFormat]) 4．FormatNumber(Expression [,NumDigitsAfterDecimal[,IncludeLeadingDigit [, UseParensForNegativeNumbers[,GroupDigits]]]]) 5．FormatPercent(Expression[,N umDigitsAfterDecimal [,IncludeLeadingDigit [, UseParensForNegativeNumbers [,GroupDigits]]]])