Hi Everybody, I am new to this forum. My question is that it’s possible to enter value in one cell and another cell which I have already set to equal then it continues to calculate. Example I set A1 = A2(I want A2 continue to calculate whenever I enter value in A1). I would be appreciated, Thanks in advance.
dont understand
A1 is set to equal A2 with the formula
=A2
so there is a formula in A1 which will be the same value as whatever is in A2
now if you enter a value into A1 - you will be overwriting the =A2 formula and so A1 will just be the value you enter into A1
what happens in A2 ?
is there a formula in A2 ?
in example spreadsheet with the required outcome would help
Last edited by etaf; 07-11-2013 at 03:50 AM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi Thuch Vannarath ,
Agree with etaf. Perhaps a workbook will help to explain.
Post a WORKBOOK.
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Sorry fo my poor english. What I want is that, whenever I enter value in A1 and A2 make calculating. For example: A1=2 then A2=2, next A1=5 then A2=7(A2 make sum from prevous value to current value in A1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks