Hi,
I have a small question, I have 2 cells, every time I add a number in the first one I need to add it to the second automatically.
How can I do that?
Thanks !
Hi,
I have a small question, I have 2 cells, every time I add a number in the first one I need to add it to the second automatically.
How can I do that?
Thanks !
Suppose your data in A1 put =A1 in A2 cell
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
Thanks for the reply.
In A2 I need the sum of A1 and A2 every time I put a new number in A1.
Something like =IF(A1>0;A2=A1+A2), obviously this does not work.
Last edited by zanga; 02-08-2011 at 05:39 AM.
I don't think it can be done by means of a formula, you will end up with a circular reference!
A couple of lines of VB code will solve it though.
Interested?
A formula will not do the trick. You will end up with a circular reference! A bit of vb code will solve it though.
Interisted?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks