Percent constant
 

I'm trying to have a percentage calculation continue down the column. I have
amount owing in A2, amount paid in B2, balance in C2, interest on that
balance in D2.

I want to have E2 include the balance from C2 plus the interest calculated
(D2) using the interest rate in cell E1.

I can't figure out how to keep this cell (E1) constant when I copy the
formula down column E.

Thanks!

Percent constant
 

I can't figure out how to keep this cell (E1) constant when I copy the
formula down column E.

Put $ signs, that'll "fix it": $E$1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---