Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
insert date | Excel Worksheet Functions | |||
quick ? on how to auto fill text from one cell to another | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel |