Update Max value

  • Thread starter Thread starter BobB
  • Start date Start date
B

BobB

I wish to update the value in cell A3 from the maximum of the input update
to cell A1 or cell A2 or the previous cell A3 value . I use the formula
=MAX(A1,A2,A3) but it is not working. Any suggestions?

Thanks,

Bob
 
Hi Bob

If you put that formula in cell A3, you will create a circular
reference, the formula is referencing the cell that contains the
formula.
Try putting in A4 or some other cell
=MAX(A1,A2,A3) or =MAX(A1:A3)
 
Roger

I don't think this approach solves my problem. I want to have a running
value of what the maximum has ever been. Let me put numbers to it.
Assume A1 is 10 and A2 is 12 and A3 is 12 (the maximum so far of A1 and A2).
The next update A2 is 11 but since it does not exceed 12, A3 remains at 12.
The next update has A2 = 13. Now A3 must be updated to 13. I realize that
my way of doing it is circular but I can't find any way to bookkeep the
"running maximum" of all A1 and A2 that have ever been input.

Bob


..
 
Hi Bob

Then if you are happy to work with a circular reference, go to
Tools>Options>Calculation>and place a tick mark against Iteration. Set
the number of iterations to something like 10.

Then in A3
=MAX(A1:A3) will work
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top