TechArena Community excel pmt gives me negative value

#1
29-05-2009
 Member Join Date: Jan 2006 Posts: 142
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
29-05-2009
 Member Join Date: Dec 2007 Posts: 1,592
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).
http://msdn2.microsoft.com/en-us/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.
#3
29-05-2009
 Member Join Date: Jun 2006 Posts: 620
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
29-05-2009
 Member Join Date: Dec 2007 Posts: 1,542
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.

 Tags: