auto cell
 

Hi, when I enter a value in column b I wish column d to auofill with the
result. Currently i have formula in d column =sumd3=+a3-b3 all the way down
the column. can i lock the formula so it can't be changes? many thanks.
a b c d


S/C DUE S/C PAID DATE PAID ARREARS
15.55 15.55
15.55 45.00 -13.90
15.55 12.00 -10.35
15.55 18.00 -12.80
15.55 2.75
15.55
15.55
15.55
15.55

auto cell
 

=D2+A3-B3
copy all the way down

"Jo" wrote:

Hi, when I enter a value in column b I wish column d to auofill with the
result. Currently i have formula in d column =sumd3=+a3-b3 all the way down
the column. can i lock the formula so it can't be changes? many thanks.
a b c d


S/C DUE S/C PAID DATE PAID ARREARS
15.55 15.55
15.55 45.00 -13.90
15.55 12.00 -10.35
15.55 18.00 -12.80
15.55 2.75
15.55
15.55
15.55
15.55