Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace cell value with cell answer
I need to have a collum A1 equaling the sum of collum B1 and C1. When I have
the answer in A1 and I type new value in B1 or C1, A1 must increase its value by the number added. eg, B1 20 C1 30 A1 50. Now I change B1 to 30 and A1 gives me 80. Can this be done? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Excel: Allow combination of formula answer and text in one cell | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
How do I multiply 1 cell x 1 cell and answer in 3rd cell? | Excel Worksheet Functions | |||
Replace a spreadsheets named cells/ranges with exact cell address. | Excel Discussion (Misc queries) |