The time now is 07/24/08 - 10:12
Log in: Username: Password:
Search forums for:
  
 
H-Desk.com Forum Index

H-Desk.com - PC Security matters - Protect your PC privacy

FAQ Search    Articles Register Log in

Excel PMT function question

H-Desk.com Forum Index -> Microsoft Office

Post new topic   Reply to topic
Author Message
vladamir



Joined: 07 Feb 2005
Posts: 59
PostPosted: 12/02/07 - 09:47    Post subject: Reply with quote
I am learning Excel and I plan to take a MOC Excel test in a near future. I am looking through some tests now and I am puzzled with a question about PMT function. Question asks to create a formula which will give positive number from PMT function. PMT function is meant to be negative. Do you know the answer for this?
Back to top
jayson



Joined: 08 Mar 2004
Posts: 96
PostPosted: 01/11/08 - 03:57    Post subject: Reply with quote
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.
Back to top
Display posts from previous:   
Post new topic   Reply to topic All times are GMT

H-Desk.com Forum Index -> Microsoft Office

Page 1 of 1

Related topics:
Excel virus takes aim at fantasy football fans
Copying Word table into Excel
Excel 2002 filename cannot be accessed
Excel 2003 Persistent Error
Excel drop down menu
xbox hard disc malfunction
Symantec Ghost functionality
Macintosh Restore system function?
Why there is no Table of Authorties function in my Word?
Operas IRC function not working
Firewalls question
HTML Question
questions about mac and security
question about wireless
Formatting Posts Question

 



Privacy Policy | Registration terms | Contact us


Discussion boards licensed and powered by ZoneX v. 3.0
Development supported by LifeForm Inc.


All Rights Reserved by H-Desk.com ©1999-2008