Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / September 2007

Tip: Looking for answers? Try searching our database.

Formulas "PPMT", "IPMT

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lisa - 11 Sep 2007 21:00 GMT
Using Excel 2003, and having a problems using formulas and then copying those
formulas and using auto fill. This is so frustrating. It would be helpful is
someone could review the worksheet to see what I am doing wrong. I don't know
how to attach the worksheet to this question.
Signature

Lisa

Peo Sjoblom - 11 Sep 2007 21:07 GMT
Post the formula and what you did expect and what you got. You cannot attach
files to a
nonbinary newsgroup and even if you could it is frowned upon and would
probably lessen your chance of getting an answer.
I'll take a shot, if you are copying formulas and they stay the same for
each row repeating the first cell's formula then you go to
tools>options>calculation and set it to automatic

If you want one cell to stay fixed and the other cell(s) to increase for
each row copied then you add a dollar sign like this

$A$1

will always point to A1 when copied down/across

Signature

Regards,

Peo Sjoblom

> Using Excel 2003, and having a problems using formulas and then copying
> those
[quoted text clipped - 3 lines]
> know
> how to attach the worksheet to this question.
joeu2004 - 11 Sep 2007 21:14 GMT
> Using Excel 2003, and having a problems using formulas and then copying those
> formulas and using auto fill. This is so frustrating. It would be helpful is
> someone could review the worksheet to see what I am doing wrong.

You could mail it to me:  joeu2004 "at" hotmail.com .  If it's not
complicated, I would be happy to take look at it.

But before you resort to that, consider this WAG:  check whether you
are using absolute and relative references correctly for your
application.

Be sure to use references of the form $A$1 when you want all the
formulas to refer to that cell.  Be sure to use references of the form
$A1 and A$1 when it makes sense for copying formulas down a row or
across columns.  And of course, be sure to use references of the form
A1 when you want the cell to track row and column changes during copy
operations.

HTH.  If not, feel free to mail the spreadsheet to me for look-see.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.