Sep 02, 2014 I have a mac and can get to Solver via my add on in tools. Is Solver in place of the Data Analysis Tool Pack? I also see some posts saying to download the StatPlus. It looks like that is for those who have excel versions pervious to 2011? Please let me know what I need to replicate the Data Analysis Tool Pack in excel 2011 for mac. Best sources of information on Excel for Mac 2011? It has been some time since I searched the web for information on Excel. Since then, v.2011 for Mac was released, Microsoft newsgroups disappeared, etc.
This article describes the formula syntax and usage of the PPMT function in Microsoft Excel. ![]() DescriptionReturns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate. SyntaxPPMT(rate, per, nper, pv, [fv], [type]) Excel 2011 For Mac Download
Note: For a more complete description of the arguments in PPMT, see PV.
The PPMT function syntax has the following arguments: Microsoft Excel 2011 Mac Manufacturer Information List
![]()
RemarksMake sure that you are consistent about the units you use for specifying rate and nper. If you make monthly payments on a four-year loan at 12 percent annual interest, use 12%/12 for rate and 4*12 for nper. If you make annual payments on the same loan, use 12% for rate and 4 for nper. Microsoft Excel 2011 Mac Manufacturer Information SystemExamplesCopy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data. Mac Makeup Manufacturer
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |