View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Formulas "PPMT", "IPMT

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
toolsoptionscalculation 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



--
Regards,

Peo Sjoblom



"Lisa" wrote in message
...
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.
--
Lisa