Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- Excel PMT Formula
- Does anyone know how to transform PV*((1+Rate)^nper) + pmt(1+rate*type) * (((1+rate)^Nper) -1 )/ rate)+ FV = 0into PMT = ?????. My maths is a little rusty. Help would be greatly appreciated.use the PMT function in Excel. stop trying to invent formulas that are already defined in excel.
- Tags: 1+Rate, Excel PMT, Microsoft Excel, PMT, programming, Simon.Edwards@...
- Q&A 2005-06-30
- The 'real' math behind Excel formulas
- Is there a way, within Excel or somewhere, to find the true mathematical calculation or equation that Excel is using when the formula is entered with a function word?For example, if I use the function formula word =AVERAGE(A1:A5), I would like to find the 'real' equation like =(A1+A2+A3+A4+A5)/5What I'm especially...
- Tags: atrav@..., Microsoft Excel, payment, PMT, software
- Q&A 2005-05-09
- Use real-life examples to teach Excel data tables
- Excel data tables aren't the easiest subjects to teach. Yet with a real-life example, your students should catch on quickly.Unless they are bankers or accountants, most of my Excel students are less than enthusiastic when it comes to learning data tables. They find it hard to relate to the complicated...
- Tags: Operational accounting, Mary Ann Richardson, car loan, payment, PMT, data table, Microsoft Excel
- Technical articles 2001-02-26
- Teach two-variable Excel data tables with real-life examples
- Looking for a great way to teach end users two-variable Excel data tables? A real-life example might just do the trick. Find out how this method works for one training pro.When teaching Excel classes, I’ve found that it pays to use real-life examples to keep users interested. In my recent...
- Tags: Operational accounting, Mary Ann Richardson, payment, new-car loan, Microsoft Excel, monthly payment, real-life example
- Technical articles 2001-03-02
- Subclassing ActiveX (zip)
- The control element accomplishes a subclassing for a window stated by its handle. The window function is the function of a window, which completely determines the behavior of the window and thus the reaction of the window to user inputs. This window function is replaced by another function by the...
- Tags: Window, ActiveX, Control Element, Window Function, Construction
- Software downloads 2008-02-13
- Windows API Hooking SDK (zip)
- Windows API Hooking SDK helps you hooking Windows APIs or functions in other DLLs, and replace the API function or DLLs' function to your own function, that is to say, intercepts Win32 functions and re-writing target function to easily custom and extend existing system or application's function, whether in an...
- Tags: Function, API, SDK, Microsoft Windows, Operating Systems, Software
- Software downloads 2005-05-18
- Excel Function Dictionary (zip)
- The Excel Function Dictionary is a file of over 150 very helpful examples of Excel function usage. The Excel Function Dictionary is created by Peter Noneley. The file is free and has been going since 1998.
- Tags: Excel Function Dictionary, Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2006-12-14
- Function Grapher (zip)
- Function Grapher is an easy-to-use software for 2D, 2.5D and 3D function graphing, animation and table data visualization. 2D and 2.5D function graphs can be plotted in Cartesian and polar coordinate systems,and 3D function graphs can be plotted in Cartesian,cylindrical and spherical coordinate systems.Version 3.3 adds axis scaling.
- Tags: 2D, GraphNow Software, Function Grapher
- Software downloads 2007-11-23
- User Defined Function (UDF) on a network
- I have created a UDF and an Excel Add-in which contains this function. I want to call this function on a spreadsheet that can be viewed by anyone in my group on our network. The problem is that even if others have the add-in installed, Excel changes the...
- Tags: Microsoft Office, PRODUCTIVITY, network, arizenn, Microsoft Excel, add-in
- Discussion threads 2007-06-08
- Key combination
- Hello. I have a Dell Latitude C800. Can anyone tell me if there is a key combination to turn off the screen?Thank youScreen disable key combinationEvery laptop/notebook should have this function. I,m not familiar with the key pattern on a Latitude but it will probably include one of the function...
- Tags: Notebooks, gbnine@..., function key
- Discussion threads 2007-06-22
- Variables in Reporting Services
- I am calling the AddTime function successfully in the detail section a table on my MS Reporting Services report. When I try to access this value using the GetMyTime function from the footer section of that same table, it comes back empty. Any ideas?Thanks, Chris-------------------Begin Code:-------------------Public lTimeTot as LongPublic Function...
- Tags: Reporting Services, Code
- Q&A 2005-11-14
- How do I enable S.M.A.R.T. function in Hard Disk?
- I want to enable S.M.A.R.T. function in my hard disk. My hard disk supports S.M.A.R.T. function but in the boot screen it shows S.M.A.R.T.- Disabled. Can anyone give me some help and tell me how to enable S.M.A.R.T. function in my hard drive.
- Tags: enabling s.m.a.r.t. function in hard disk, hard drive, off-topic, S.M.A.R.T., S.M.A.R.T. function, sulabh08@...
- Discussion threads 2006-10-06
- JavaScript: Document Object Model
- I have recently converted my Client-end scripts to 'JavaScript' from the original 'VBScript'. I did this as Netscape & other browsers except IE would not support VBScript. Yet the problem is not solved. I have written a validation function in tag. I address the form controls by the DOM...
- Tags: XML, Scripting languages, Web browsers
- Q&A 2004-12-21
- A Clever Demonstration of the SAS SUBSTR Function
- The SAS SUBSTR function differs from the substring function in other programming languages as it can be used on either side of the assignment operator. This paper demonstrates its practical usage by building programs to separate and manipulate text. Specific topics include: Proper Syntax Use; Comparison with the COLON MODIFIER;...
- Tags: SAS Institute, SAS SUBSTR Function
- White papers 2005-03-09
- MS Excel Concatenate function
- I have an user who needs a very specific result from his Excel spreadsheet when he uses the Concatenate function. He wants each separate piece of data to line up in the column with the Concatenate function. Some of the cells used for the information need to show the first...
- Tags: Microsoft Office, Microsoft Corp., kwales52000@..., Microsoft Excel
- Discussion threads 2007-07-19
- Can a PDF document call a function from an external dll?
- Hello, everyone. I have a requirement to call an external function from a library dll, from within the pdf file. Can some of the software masters out there help me with this subject? I am greatly appreciate for your help. If you know another way of...
- Tags: tienchau2000@..., Adobe PDF
- Discussion threads 2007-03-05
- Access Ontimer function
- I have a database that uses the Ontimer function to generate a real time clock onscreen. I have found that for some reason, if for instance, Iopen up another form then cose it, the front end form stops monitoring the Ontimer function and my clock stops running up. Anyone know...
- Tags: Ontimer function, OnTimer, tonymcveigh@..., software, Access Ontimer, Microsoft Access
- Q&A 2006-07-04
- Keyboard Function
- Please help me... i want to know how to enable the disabled function of ctrl+alt+del... and other special function of computer keyboard...Check with your AdminIf these functions are disabled, it is most likely that your system admin has set a group policy or other restriction to limit what users can...
- Tags: hardware, keyboard, nicy031086@..., windows
- Discussion threads 2007-01-14
- Sicyon Lite (exe)
- Sicyon is all-in-one freeware tool for every scientist. The core of Sicyon is an VBScript/JScript scripter and the principal features are: estimate a function using variables and user-defined functions; matrix operations; plot/tabulate a function; find real roots, minimums, maximums and definite integral of a function; fit a function over data...
- Tags: Function, Freeware, Sicyon, Productivity, Scripting Languages, Software/Web Development, Web Development
- Software downloads 2006-02-09
- << Previous
- page 1 of 1
- Next >>
