excel pmt gives me negative value

[Nadeem]

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

[Expertz]

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/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.

[Gusgr8]

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.

[Team Leader]

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