資源描述：
《excelvba函數(shù)參考手冊》由會員上傳分享，免費在線閱讀，更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫。
1、ExcelVBA學(xué)習(xí)資料函數(shù)參考手冊摘自Excel2003VBA幫助2006年12月29日第115頁ExcelVBA學(xué)習(xí)資料1函1數(shù)1參1考1手1冊1摘自Excel2003VBA幫助12006年12月29日Abs函數(shù)1Abs函數(shù)6導(dǎo)出的數(shù)學(xué)函數(shù)6Array函數(shù)7Asc函數(shù)8Atn函數(shù)9CallByName函數(shù)9CBool等類型轉(zhuǎn)換函數(shù)10語法10返回類型10說明11Choose函數(shù)13Chr函數(shù)14Command函數(shù)15Cos函數(shù)16CreateObject函數(shù)17CurDir函數(shù)18CVErr函
2、數(shù)19Date函數(shù)20DateAdd函數(shù)20DateDiff函數(shù)21DatePart函數(shù)23DateSerial函數(shù)25DateValue函數(shù)26Day函數(shù)27DDB函數(shù)27Dir函數(shù)28DoEvents函數(shù)30Environ函數(shù)31EOF函數(shù)32Error函數(shù)33Exp函數(shù)33FileAttr函數(shù)34FileDateTime函數(shù)34第115頁FileLen函數(shù)35Filter函數(shù)35Fix、Int函數(shù)36Format函數(shù)37FormatCurrency函數(shù)40FormatDateTime函數(shù)41
3、FormatNumber函數(shù)41FormatPercent函數(shù)42FreeFile函數(shù)43FV函數(shù)44GetAllSettings函數(shù)45GetAttr函數(shù)46GetObject函數(shù)47GetSetting函數(shù)51Hex函數(shù)52Hour函數(shù)52IIf函數(shù)53IMEStatus函數(shù)53Input函數(shù)54InputBox函數(shù)55InStr函數(shù)57InStrRev函數(shù)58IPmt函數(shù)60IRR函數(shù)61IsArray函數(shù)62IsDate函數(shù)63IsEmpty函數(shù)63IsError函數(shù)64IsMissing
4、函數(shù)64IsNull函數(shù)65IsNumeric函數(shù)66IsObject函數(shù)67Join函數(shù)67LBound函數(shù)67LCase函數(shù)68Left函數(shù)69Len函數(shù)70Loc函數(shù)71LOF函數(shù)71Log函數(shù)72LTrim、RTrim與Trim函數(shù)72MacID函數(shù)73MacScript函數(shù)75Mid函數(shù)75第115頁Minute函數(shù)76MIRR函數(shù)76Month函數(shù)77MonthName函數(shù)78MsgBox函數(shù)78Now函數(shù)81NPer函數(shù)81NPV函數(shù)83Oct函數(shù)84Partition函數(shù)84Pmt
5、函數(shù)86PPmt函數(shù)87PV函數(shù)89QBColor函數(shù)90Rate函數(shù)91Replace函數(shù)92RGB函數(shù)94Right函數(shù)95Rnd函數(shù)96Round函數(shù)96Second函數(shù)97Seek函數(shù)97Sgn函數(shù)98Shell函數(shù)99Sin函數(shù)100SLN函數(shù)101Space函數(shù)102Spc函數(shù)102Split函數(shù)103Sqr函數(shù)104Str函數(shù)104StrComp函數(shù)105StrConv函數(shù)106StrReverse函數(shù)107String函數(shù)108Switch函數(shù)108SYD函數(shù)109Tab函數(shù)110
6、Tan函數(shù)111Time函數(shù)112Timer函數(shù)112TimeSerial函數(shù)112TimeValue函數(shù)113TypeName函數(shù)114第115頁UBound函數(shù)115UCase函數(shù)116Val函數(shù)116VarType函數(shù)117Weekday函數(shù)118WeekdayName函數(shù)119Year函數(shù)120第115頁Abs函數(shù)返回參數(shù)的絕對值，其類型和參數(shù)相同。語法Abs(number)必要的number參數(shù)是任何有效的數(shù)值表達式，如果number包含Null，則返回Null，如果number是未初始
7、化的變量，則返回0。說明一個數(shù)的絕對值是將正負號去掉以后的值。例如，ABS(-1)和ABS(1)都返回1。Abs函數(shù)示例本示例使用Abs函數(shù)計算數(shù)的絕對值。DimMyNumberMyNumber=Abs(50.3)'返回50.3。MyNumber=Abs(-50.3)'返回50.3。請參閱：Sgn函數(shù)、數(shù)學(xué)函數(shù)中的Abs函數(shù)、Atn函數(shù)、Cos函數(shù)、Exp函數(shù)、Fix函數(shù)、Int函數(shù)、Log函數(shù)、Rnd函數(shù)、Sgn函數(shù)、Sin函數(shù)、Sqr函數(shù)、Tan函數(shù)、導(dǎo)出的數(shù)學(xué)函數(shù)：導(dǎo)出的數(shù)學(xué)函數(shù)以下為非基本
8、數(shù)學(xué)函數(shù)的列表，皆可由基本數(shù)學(xué)函數(shù)導(dǎo)出：函數(shù)由基本函數(shù)導(dǎo)出之公式Secant（正割）Sec(X)=1/Cos(X)Cosecant（余割）Cosec(X)=1/Sin(X)Cotangent（余切）Cotan(X)=1/Tan(X)InverseSine（反正弦）Arcsin(X)=Atn(X/Sqr(-X*X+1))InverseCosine（反余弦）Arccos(X)=Atn(-X/Sqr(-X*X+1))+2*Atn(1)InverseSecant（反正割）Arcsec(X)
