• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How can I accumulate values from a cell that is constantly changing it content?

emvodream

New Member
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
Do You expect to get VBA Macros -solution?
You're writing about formulas ... formulas.
... and all something, You're interesting to get without a sample Excel-file, which has some sample data as well as expected results ... hmm?
 
Back
Top