CUMIPMT
Trying to figure the total interest paid between a start_period and
end_period. I used "CUMIPMT to give the correct amount but it is a negative value and I can't use it's negative value when adding a column. I need a positive value. Can anyone help. Thanks |
Thank You - That solved the problem
"Maglor" wrote: make the 'pv' a negative value of put a '-' in front of the function's name. On Mon, 14 Feb 2005 06:13:03 -0800, Dorlon wrote: Trying to figure the total interest paid between a start_period and end_period. I used "CUMIPMT to give the correct amount but it is a negative value and I can't use it's negative value when adding a column. I need a positive value. Can anyone help. Thanks |
All times are GMT +1. The time now is 10:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com