How can I accumulate values from a cell that is constantly changing it content?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Accumulate values from a cell that is constantly changing it content
0
Discussion
Please edit your question to illustrate what you mean. Over what period do you want to accumulate values and where? It's always helps us if you can attach a workbook to your question.
John_Ru (rep: 6142) May 27, '21 at 5:52 pm
How can I accumulate values from a cell that is constantly changing it content?
In cell A3 I have a price coming from the web and it is constantly changing value.
I cell B2 I have another price (this price never changes).
In cell B3 I have a formula to calculate 10% if the changing price is lower than the permanent price as =MAX(A3,B2)*0.1
Now, what I need is accumulate the value resulting from that formula (result from the formula changes frequently depending on the value which is coming from the web and it is constantly changing.)
emvodream (rep: 2) May 27, '21 at 6:10 pm
Duplicate question
For the future, please be sure to post no significant parts of your question in the "Discussion" section. If you want a good answer you must post a good question. As for this "question", I suggest you delete it and go with the other thread where you already have an answer.
For the future, please be sure to post no significant parts of your question in the "Discussion" section. If you want a good answer you must post a good question. As for this "question", I suggest you delete it and go with the other thread where you already have an answer.
Variatus (rep: 4889) May 27, '21 at 7:16 pm
I don't understand what you are saying
emvodream (rep: 2) May 27, '21 at 7:53 pm
Your question is too imprecise. Therefore John asked for more detail. You should provide that detail by editing your question, not as a "Discussion". This is a Q & A forum, not a discussion blog. You should ask precise questions and expect precise answers.
Variatus (rep: 4889) May 28, '21 at 12:13 am