Thread: auto cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jo Jo is offline
external usenet poster
 
Posts: 113
Default 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