Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 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.
Reply With Quote
  #2  
Old 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).
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.
Reply With Quote
  #3  
Old 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.
Reply With Quote
  #4  
Old 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.

Here is a link that gives info about nesting functions http://www.bettersolutions.com/excel...I749589511.htm
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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 25-02-2012 12:25 PM
Want to page negative time via paste special in Excel Ojsuta MS Office Support 4 24-02-2012 01:52 PM
How to get negative variance percentage figures in Microsfot Excel Zebadiah MS Office Support 4 24-01-2012 05:04 PM
Automatically display negative numbers in red in Excel 2007 SpearMan Tips & Tweaks 2 19-03-2009 11:10 PM
Negative hours message problem in Excel 2003 Damien25 Windows Software 3 04-02-2009 05:07 PM


All times are GMT +5.5. The time now is 10:48 AM.