- Copyright
- Preface
- The Basics
- Reference
- The Language Reference
- The Language Reference, Part 1: #Const Directive–Drives Collection Object (VB6)
- #Const Directive
- #If...Then...#Else Directive
- Abs Function
- AddressOf Operator
- AppActivate Statement
- Array Function
- Asc, AscB, AscW Functions
- Atn Function
- Beep Statement
- BindingCollection Object (VB6)
- BindingCollection.Add Method (VB6)
- BindingCollection.Clear Method (VB6)
- BindingCollection Remove.Method (VB6)
- Binding Object (VB6)
- Calendar Property
- Call Statement
- CallByName Function (VB6)
- CBool Function
- CByte Function
- CCur Function
- CDate Function
- CDbl Function
- CDec Function
- ChDir Statement
- ChDrive Statement
- Choose Function
- Chr, Chr$, ChrB, ChrB$, ChrW Functions
- CInt Function
- CLng Function
- Close Statement
- Collection Object
- Collection.Add Method
- Collection.Count Property
- Collection.Item Method
- Collection.Remove Method
- Command Function
- Const Statement
- Cos Function
- CreateObject Function
- CSng Function
- CStr Function
- CurDir, CurDir$ Functions
- CVar Function
- CVDate Function
- CVErr Function
- Data Binding Objects (VB6)
- Data Format Objects (VB6)
- DataBindingBehavior Property (VB6 only)
- DataSourceBehavior Property (VB6 only)
- Date, Date$ Functions
- Date Statement
- DateAdd Function
- DateDiff Function
- DatePart Function
- DateSerial Function
- DateValue Function
- Day Function
- DDB Function
- Debug Object
- Debug.Assert Method
- Debug.Print Method
- Declare Statement
- Def... Statement
- DeleteSetting Statement
- Dictionary Object (VB6)
- Dictionary.Add Method (VB6)
- Dictionary.CompareMode Property (VB6)
- Dictionary.Count Property (VB6)
- Dictionary.Exists Method (VB6)
- Dictionary.Item Property (VB6)
- Dictionary.Items Method (VB6)
- Dictionary.Key Property (VB6)
- Dictionary.Keys Method (VB6)
- Dictionary.Remove Method (VB6)
- Dictionary.RemoveAll Method (VB6)
- Dim Statement
- Dir, Dir$ Functions
- Do...Loop Statement
- DoEvents Function
- Drive Object (VB6)
- Drives Collection Object (VB6)
- The Language Reference, Part 2: End... Statement–FV Function
- End... Statement
- Enum Statement
- Environ, Environ$ Functions
- EOF Function
- Erase Statement
- Err Object
- Err.Clear Method
- Err.Description Property
- Err.HelpContext Property
- Err.HelpFile Property
- Err.LastDLLError Property
- Err.Number Property
- Err.Raise Method
- Err.Source Property
- Error, Error$ Functions
- Error Statement
- Event Statement
- Exit Statement
- Exp Function
- File Object (VB6)
- File.Copy Method (VB6)
- File.Delete Method (VB6)
- File.Move Method (VB6)
- File.OpenAsTextStream Method (VB6)
- File System Object Model (VB6)
- FileAttr Function
- FileCopy Statement
- FileDateTime Function
- FileLen Function
- Files Collection Object (VB6)
- FileSystemObject Object (VB6)
- FileSystemObject.BuildPath Method (VB6)
- FileSystemObject.CopyFile Method (VB6)
- FileSystemObject.CopyFolder Method (VB6)
- FileSystemObject.CreateFolder Method (VB6)
- FileSystemObject.CreateTextFile Method (VB6)
- FileSystemObject.DeleteFile Method (VB6)
- FileSystemObject.DeleteFolder Method (VB6)
- FileSystemObject.DriveExists Method (VB6)
- FileSystemObject.Drives Property (VB6)
- FileSystemObject.FileExists Method (VB6)
- FileSystemObject.FolderExists Method (VB6)
- FileSystemObject.GetAbsolutePathName Method (VB6)
- FileSystemObject.GetBaseName Method (VB6)
- FileSystemObject.GetDrive Method (VB6)
- FileSystemObject.GetDriveName Method (VB6)
- FileSystemObject.GetExtensionName Method (VB6)
- FileSystemObject.GetFile Method (VB6)
- FileSystemObject.GetFileName Method (VB6)
- FileSystemObject.GetFolder Method (VB6)
- FileSystemObject.GetParentFolderName Method (VB6)
- FileSystemObject.GetSpecialFolder Method (VB6)
- FileSystemObject.GetTempName Method (VB6)
- FileSystemObject.MoveFile Method (VB6)
- FileSystemObject.MoveFolder Method (VB6)
- FileSystemObject.OpenTextFile Method (VB6)
- Filter Function (VB6)
- Fix Function
- Folder Object (VB6)
- Folder.Copy Method (VB6)
- Folder.CreateTextFile Method (VB6)
- Folder.Delete Method (VB6)
- Folder.Move Method (VB6)
- Folders Collection Object (VB6)
- Folders.Add Method (VB6)
- For...Next Statement
- For Each...Next Statement
- Format, Format$ Functions
- FormatCurrency, FormatNumber, FormatPercent Functions (VB6)
- FormatDateTime Function (VB6)
- FreeFile Function
- Function Statement
- FV Function
- The Language Reference, Part 3: Get Statement–PV Function
- Get Statement
- GetAllSettings Function
- GetAttr Function
- GetAutoServerSettings Function
- GetObject Function
- GetSetting Function
- GoSub...Return Statement
- Goto Statement
- Hex, Hex$ Functions
- Hour Function
- If...Then...Else Statement
- IIf Function
- IMEStatus Function
- Implements Statement
- Initialize Event
- Input, Input$, InputB, InputB$ Functions
- Input # Statement
- InputBox Function
- Instancing Property (VB only)
- InStr, InStrB Functions
- InstrRev Function (VB6)
- Int Function
- IPmt Function
- IRR Function
- IsArray Function
- IsDate Function
- IsEmpty Function
- IsError Function
- IsMissing Function
- IsNull Function
- IsNumeric Function
- IsObject Function
- Join Function (VB6)
- Kill Statement
- LBound Function
- LCase, LCase$ Functions
- Left, Left$, LeftB, LeftB$ Functions
- Len, LenB Functions
- Like Operator
- Line Input# Statement
- Load Statement
- LoadResData Function
- LoadResPicture Function
- LoadResString Function
- Loc Function
- Lock Statement
- LOF Function
- Log Function
- LSet Statement
- LTrim, LTrim$ Functions
- Me Operator
- Mid, Mid$, MidB, MidB$ Functions
- Mid, MidB Statements
- Minute Function
- MIRR Function
- MkDir Statement
- Month Function
- MonthName Function (VB6)
- MsgBox Function
- MTSTransactionMode Property (VB6 only)
- Name Property
- Name Statement
- Now Function
- NPer Function
- NPV Function
- Oct, Oct$ Functions
- On Error Statement
- Open Statement
- Option Base Statement
- Option Compare Statement
- Option Explicit Statement
- Option Private Module Statement
- Persistable Property (VB6 Only)
- Pmt Function
- PPmt Function
- Print # Statement
- Printer Object and Printers Collection
- Private Statement
- Property Get Statement
- Property Let Statement
- Property Set Statement
- Public Statement
- Put Statement
- PV Function
- The Language Reference, Part 4: QBColor Function–Year Function
- QBColor Function
- RaiseEvent Statement
- Randomize Statement
- Rate Function
- ReDim Statement
- Rem Statement
- Replace Function (VB6)
- Reset Statement
- Resume Statement
- Return Statement
- RGB Function
- Right, Right$, RightB, RightB$ Functions
- RmDir Statement
- Rnd Function
- Round Function
- RSet Statement
- RTrim, RTrim$ Functions
- SaveSetting Statement
- Second Function
- Seek Function
- Seek Statement
- Select Case Statement
- SendKeys Statement
- Set Statement
- SetAttr Statement
- Sgn Function
- Shell Function
- Sin Function
- SLN Function
- Space, Space$ Functions
- Spc Function
- Split Function (VB6)
- Sqr Function
- Static Statement
- stdDataFormat Object (VB6)
- stdDataFormats Object (VB6)
- Stop Statement
- Str, Str$ Functions
- StrComp Function
- StrConv Function
- String, String$ Functions
- StrReverse Function (VB6)
- Sub Statement
- Switch Function
- SYD Function
- Tab Function
- Tan Function
- Terminate Event
- TextStream Object
- TextStream.Close Method
- TextStream.Read Method
- TextStream.ReadAll Method
- TextStream.ReadLine Method
- TextStream.Skip Method
- TextStream.SkipLine Method
- TextStream.Write Method
- TextStream.WriteBlankLines Method
- TextStream.WriteLine Method
- Time, Time$ Functions
- Time Statement
- Timer Function
- TimeSerial Function
- TimeValue Function
- Trim, Trim$ Functions
- Type Statement
- TypeName Function
- UBound Function
- UCase, UCase$ Functions
- Unload Statement
- Unlock Statement
- Val Function
- VarType Function
- Weekday Function
- WeekdayName Function (VB6)
- While...Wend Statement
- Width # Statement
- With Statement
- WithEvents Keyword
- Write # Statement
- Year Function
- Appendixes
- Language Elements by Category
- Collection Object
- Conditional Compilation
- Data Type Conversion Functions
- Data Bindings Objects (VB6 only)
- Date and Time Functions
- Dictionary Object (VB6 Only)
- Err Object
- FileSystem Objects (VB6 only)
- File and Folder Handling
- Financial Functions
- Formatting Functions
- Information Functions
- Interaction Functions
- Math Functions
- Programming and ActiveX Programming
- Printer Object
- Program Structure and Flow
- Registry Functions
- String Manipulation
- Variable Declaration
- Language Constants
- Application Window Style (VbAppWinStyle)
- Calendar (VBCalendar)
- Call Type (VB6 only)
- Compare Method (VbCompareMethod)
- Data Binding Update Mode (VB6 Only)
- Date Time Format Styles (VB6 Only)
- Day of Week (VbDayOfWeek)
- Drive Type (VB6 only)
- File Attributes (VbFileAttribute)
- File System Objects File Attributes (VB6 Only)
- First Week of Year (VbFirstWeekOfYear)
- IME Status (VbIMEStatus)
- Language Constants
- Log Event Type Style (LogEventTypeConstants)
- Log Mode Constants (VB6 only)
- Message Box Result (VbMsgBoxResult)
- Message Box Style (VbMsgBoxStyle)
- Special Folder Types (VB6 only)
- String Conversion (VbStrConv)
- TextStream IOMode (VB6 only)
- Tristate Constants (VB6 Only)
- Variant Type (VbVarType)
- Operators
- What's New in VB6?
- Language Elements by Category
- Colophon
- Index
A.10. Financial Functions
FV Function
Returns the future value of an annuity
IPmt Function
Returns the interest payment for a given period of an annuity
IRR Function
Returns the internal rate of return for a series of periodic cash flows
MIRR Function
Returns the modified internal rate of return for a series of periodic cash flows
NPer Function
Returns the number of periods for an annuity
NPV Function
Returns the net present value of an investment
Pmt Function
Returns the payment for an annuity
PPmt Function
Returns the principal payment for a given period of an annuity
PV Function
Returns the present value of an annuity
Rate Function
Returns the interest rate per period for an annuity
SLN Function
Returns the straight-line depreciation of an asset for a single period
SYD Function
Returns the sum-of-years' digits depreciation on an asset
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.