

 Thread Tools  Search this Thread 
#1
 
 
excel pmt gives me negative value I am using Excel 2002 and I am having problem with a PMT. I have made a field with the percentage rate that is a variable which is pulled by value of cell A2 and so on. When I finish my code I always get a negative value or number which messes up my calculations that I want to make for future. Can anyone help me outta this. Thank you
__________________ Fear is only in your mind, Dont Let It Overcome You. 
#2
 
 
Re: excel pmt gives me negative value Well that's a curious question since the function is supposed to return a negative (PMT is the amount to be deducted from the amount owed). This article http://msdn2.microsoft.com/enus/library/hyd90ysd.aspx does use the (principal) method to return a positive result. Payment = Pmt(APR / 12, TotPmts, PVal, FVal, PayType) Wouldn't say that's a definitive "accepted Microsoft solution" though.
__________________ Education, Career and Job Discussions 
#3
 
 
Re: excel pmt gives me negative value PMT function in Excel is meant to be negative but when you work with several linked spreadsheets you might need positive value for some other calculations. Anyway, to make PMT function give you a positive number just place a minus () sign in front of the function. Mathematically it will give you a positive value. 
#4
 
 
Re: excel pmt gives me negative value For the =Average function, you will need to enclose the average function with the =round function. Called nesting of functions. If you need to understand the round function go through the same principles as I have mentioned in my previous post, only use round instead of pmt. Here is a link that gives info about nesting functions http://www.bettersolutions.com/excel...I749589511.htm 

Tags: excel 2002, pmt 
Thread Tools  Search this Thread 

Similar Threads for: "excel pmt gives me negative value"  
Thread  Thread Starter  Forum  Replies  Last Post 
How to position X axis in Excel chart with negative values in it  Nikhilas  MS Office Support  3  25022012 12:25 PM 
Want to page negative time via paste special in Excel  Ojsuta  MS Office Support  4  24022012 01:52 PM 
How to get negative variance percentage figures in Microsfot Excel  Zebadiah  MS Office Support  4  24012012 05:04 PM 
Automatically display negative numbers in red in Excel 2007  SpearMan  Tips & Tweaks  2  19032009 11:10 PM 
Negative hours message problem in Excel 2003  Damien25  Windows Software  3  04022009 05:07 PM 