Copying Interest formula to 214 cells.

[BradP]

I am doing a project for work and need to copy a interest formula to th
next 214 months (Ipmt function). Ii am receiving an error when I try t
fill the remind cells.

Is there a way to copy that formula?








Savings Goal - $750,000
Term - 10 years
Interest - 5.5

 

[Don Guillett]

Maybe you could post your formula for comments.

 

[BradP]

I will re-type the question so that it is easier to read and less word
spelled wrong.

I am tried today I went to the basketball last night

 

[Frank Kabel]

Hi
what formula are you using and what exact error did you get?

 

[Norman Harker]

Hi BradP!

If you are happy with the first answer you get, then concentrate on
the absolute relative and mixed cell referencing in the formula before
you copy down or across.

See:
Chip Pearson:
http://www.cpearson.com/excel/relative.htm