- Abs Returns the absolute value of a number. - ABS Asc Returns the integer value of a character. - Atn Returns the arctangent of a number. - Cos Returns the cosine of a number that is an angle specified in radians.. - Exp Returns the value of the base of the natural logarithm (e) raised to the exponent you supply.. - See also Log.. - Fix Returns the value of the number you supply truncated to an integer. - If the number is negative, Fix returns the first integer that is greater than or equal to the number.. - See also Int.. - Chapter A3 Chapter A3 Ar ticle 3 Chapter A3 Ar ticle 3 C hapter A3. - Int Returns the value of the number you supply trun- cated to an integer. - If the number is negative, Int returns the first integer that is less than or equal to the number. - See also Fix.. - IPmt Returns the interest payment for a given period of an annuity.. - IRR Returns the internal rate of return for a series of periodic cash flows.. - LBound Returns the lowest available subscript for the array and dimension you specify. - See also UBound.. - Log Returns the natural logarithm of the number you supply. - See also Exp.. - MIRR Returns the modified internal rate of return for a series of periodic cash flows.. - NPer Returns the number of payment periods for an annuity.. - NPV Returns the net present value of an investment. - (none) Pmt Returns the payment required for an annuity. - (none) PPmt Returns the amount applied to principal for a. - PV Returns the present value of an annuity. - (none) Rate Returns the interest rate of an annuity. - Sin Returns the sine of a number that is an angle specified in radians.. - SLN Returns the straight-line depreciation of an asset for a single period.. - Sqr Returns the square root of a number. - SYD Returns the sum-of-the-years’ digits depreciation of an asset.. - Tan Returns the tangent of a number that is an angle specified in radians.. - UBound Returns the highest available subscript for the array and dimension you specify. - See also LBound.. - Chapter A3 Chapter A3 Article 3 Chapter A3 Article 3 Chapter A3 Table A3-2. - CAST, CONVERT CDate Converts a value to Date/Time data type. - Date/Time Functions. - Date Returns the current system date as a Variant data type.. - DateValue Returns the date portion of a date/time value. - CAST, CONVERT Day Returns the numeric day portion of a date/time. - See also DatePart.. - Hour Returns the hour portion of a date/time value.. - Minute Returns the minute portion of a date/time value. - Month Returns the numeric month portion of a date/time value. - MonthName Returns the name of the month of a date/time value.. - Now Returns the current system date and time as a Variant data type.. - Second Returns the seconds portion of a date/time value. - Time Returns the current system time as a Variant data type.. - Chapter A3 Chapter A3 Article 3 Chapter A3 Article 3 Chapter A3 TimeSerial Returns a time value calculated from supplied. - TimeValue Returns the time portion of a date/time value. - CAST, CONVERT WeekDay Returns the integer day of the week from a. - date/time value. - WeekDayName Returns the name of the day from a date/time value.. - Year Returns the year portion of a date/time value.. - IsArray Returns True if the argument you supply is an array. - (none) IsDate Returns True if the argument you supply can be converted. - IsEmpty Returns True if the Variant argument you supply has never been initialized.. - IsError Returns True if the number you supply is a valid error value. - IsNull Returns True if the argument you supply is the Null value.. - IsObject Returns True if the argument you supply is an object variable.. - Sgn Returns an indication whether the number you supply is negative, positive, or zero.. - Evaluates the expressions left to right and returns the secondary expression for the first primary expression that evaluates to True.. - TypeName Returns the data type of the variable or expression you supply as a spelled out name of the data type. - See also VarType.. - VarType Returns an integer code indicating the data type of the variable or expression you supply. - See also TypeName.. - Chapter A3 Chapter A3 Article 3 Chapter A3 Article 3 Chapter A3 Table A3-5. - SQL Server Equivalent Chr Returns the character value of an integer. - FormatCurrency Formats the number you supply as a currency string.. - CAST or CONVERT with limitations FormatDateTime Formats the date/time value you supply as a. - CAST or CONVERT with limitations FormatNumber Formats the number you supply as a string. - See also Str.. - FormatPercent Multiplies the number you supply by 100 and returns a string with a trailing percent. - (base 16) value of the number you supply.. - InStr Returns the integer offset position of a search string within another string, searching the target string from the beginning.. - InStrRev Returns the integer offset position of a search string within another string, searching the target string from the end.. - Join Concatenates the one-dimensional array you supply into a single string separated by the delimiter you specify. - See also Split.. - See also UCase and StrConv.. - Left Returns the requested number of leftmost characters from a string.. - Len Returns the current length of a string. - Mid Returns the specified number of characters starting from a specified position in the middle of a string.. - Oct Returns a string containing the octal (base 8) value of the number you supply.. - Partition Returns a string range name for a numeric variable based on the range start, stop, and interval values you supply.. - Replace Examines a string you supply and returns a string with all occurrences of one string replaced by another string.. - Right Returns the requested number of rightmost characters from a string.. - It fills the array with the substrings it finds by parsing a string you supply with a delimiter you specify. - See also Join.. - See also LCase and UCase.. - StrReverse Returns a string in which the order of characters in the string you supply is reversed.. - String Returns a string of the length you specify filled with the character that you supply.. - See also LCase and StrConv.. - Chapter A3 Chapter A3 Article 3 Chapter A3 Article 3 Chapter A3 Table A3-6. - Command Returns the string of characters following the /cmd switch in the command or shortcut you used to start your application.. - CurDir Returns the current path or the current path on the specified drive.. - FileDateTime Returns the create date or the last modification date of the file path you specify.. - FileLen Returns the size of the file path you specify.. - GetAttr Returns the attributes of the file or path you specify.. - InputBox Prompts the user with a message you supply and returns the user response.. - MsgBox Displays a message you supply in a dialog box and returns an indica- tion of which button the user clicked in response.. - RGB Returns the RGB value based on red, green, and blue values you supply.
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt