Software

Ask something
Discussion Locked

Excel formula

0 helpful
6 replies

by ichu50

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Please help
Value in Cell A1 is copied into cell B1 and new value is entered in A1
B1 should now show old value of A1 plus new value of A1
in other words B1=B1+A1
How do I do this in Excel. Tried to use if statement, cant figure it out
Thanks

6 replies

by ltop

You will need to use a VB macro or similar in excel to get anything like the result you are looking for.

You will not get it from any excel formula that I am aware of.

let us know how u get on,

cheers

by ltop

The answer from chitosunday is correct,

A1 input as 10
B1 is entered as =A1
Copy / Paste Special from A1 > B1 changes the formula in B1 to now be =(A1)+10.

Each time you change the value in A1, B1 will update the value as per the formula, or if you want it to add A1 to the already changed B1, then you need to go thru the Copy / Paste Special action again and every time,

cheers

by chitosunday

You can use copy paste special add. Input the new data then copy cell a1 then use paste special, add to cell b1

by ichu50

Thank you all. I figured it out.
Turn on Iteration and change Maximum iteration to 1 (Tools --> Options --> Calculation tab)

In cell B1 type =B1+A1
Change the numbers in A1 and see the amazing results

by johnske

This is a VBA solution, paste this into the worksheet module for the sheet you want this to work for...

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
If Target = [a1] Then [b1] = [a1] + [b1]
End Sub

This discussion is closed to new replies.