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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

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

Is there a way to copy that formula?








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


---
Message posted from http://www.ExcelForum.com/