Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Flying_Dutcman
Only with VBA code ( change event ) Copy this event in the sheet module in a test workbook Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 Or Target.Column = 3 Then Cells(Target.Row, 1).Value = Cells(Target.Row, 1).Value + Target.Value End If End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Flying_Dutcman" wrote in message ... 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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
"Flying_Dutcman" wrote in message
... 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? I'm not sure what you are saying. What formula have you in A1? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=(b1+c1)
"Gordon" wrote: "Flying_Dutcman" wrote in message ... 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? I'm not sure what you are saying. What formula have you in A1? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
"Flying_Dutcman" wrote in message
... "Gordon" wrote: "Flying_Dutcman" wrote in message ... 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? I'm not sure what you are saying. What formula have you in A1? =(b1+c1) No, because 30 + 30 does NOT = 80. Why should you want to show that 30 + 30 = 80? If you want to do that, then you need to ADD 30 to cell B1 so that cell B1 reads "20 + 30". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |