Home > Microsoft Office > Excel > Negative Amortization Table - Excel
Negative Amortization Table - Excel
How to display positive values in your amortization table, which automatically produces negative values. This process also works in Excel 2013 & 2010.
Negative value display:
Excel automatically produces negative values in an amortization table. You have to put a minus sign in front of the cell addresses which contain the amount borrowed or in front of the actual amount borrowed to make the values positive.
Another example:
=PMT(D4/12,D6, -D3)
| Author: karperc | Last Updated: 3/26/2018 12:28 PM | Page Views: 1248 |
helpdesk.etown.edu/helpconsole2012/kb/default.aspx?pageid=negative_amortization_table
|