0
What function do you use in Excel 2010 for an amortization table?
Wiki User
∙ 9y ago
PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.
PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.
PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.
PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.
PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.
PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.
PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.
PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.
PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.
PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.
PMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.
Wiki User
∙ 9y ago
Wiki User
∙ 9y agoPMT would be the most common function used, but depending on exactly what you are trying to do, you could use others like the IPMT for interest payment and the PPMT for the principal payment.
Add your answer:
Earn +20 pts
What is the meaning of ms Excel 2010?
ms excel 2010
Which Excel 2010 ribbon command located on the Formulas tab has a larger F next to the little x?
Insert Function is the Excel ribbon command on the Formulas tab that is marked "Fx"
Is there a quotient function in Microsoft Excel?
Some versions of Excel do not have it but versions since Excel 2010 all do. Prior to that, you could get it in other ways, like using the INT function on the result of a division. So it could be done in these ways, where you are using the cells A5 and D5 in the calculation. =QUOTIENT(A5,D5) =INT(A5/D5)
How do you play billiards in Excel 2010?
There are no hidden games in Microsoft Excel 2010. The last version that had a hidden game was in Excel 2000. There is a game called Billiards Excel and there are Billiard 2010 games, but these have nothing to do with Microsoft Excel, or any Microsoft software.
Can you use Excel 2010 as Excel 2007?
The differences between them are not extensive so you can work in Excel 2010 easily if you are familiar with Excel 2007. You can save your files so that Excel 2007 will recognise them.
How many rows and columns in Excel 2010?
There are 1,048,576 rows and 16,384 columns in Excel 2010
What you learn about Excel 2010?
There is a lot to learn about Excel 2010. If you have never used any version of Excel, then a good course about it or even a good book will help. If you have used older versions of Excel, then you would not have much problem learning to use Excel 2010.
How can I connect tabs in Excel 2010 with information in the spreadsheet itself?
For detailed information on how to connect tabs in Excel 2010 spreadsheet visit keynotesupport.com/excel-basics/excel-linking-worksheets.shtml
What cntrl button copies in Excel 2010?
Ctrl - C will copy in Excel 2010 and in other versions.
How can you sort by two values on a pivot table on excel 2010 e.g. Sorting by points and then goal difference in a football league table?
If you double click on the last columns header you can open the pivot table window. Then click on Advanced then in the new window and select the Autosort option using the fields you need. You can do a league table in an ordinary table in Excel, not a pivot table. You can use an advanced sort and use the fields you want to do your sort on, choosing them in the sequence you mentioned. That may be easier.
Does installing Excel 2013 remove Excel 2010?
Not necessarily. You can have two versions of Excel on one computer.
What is the Microsoft version of Excel before 2013 came out?
Microsoft Excel 2010.
