Updating Maximum

[BobB]

I would like to calculate the maximum of two cells and place it in a third
cell if the value is larger than the value already in the third cell from a
previous calculation, i.e. yesterday's data. I am able to do it for one
cell with "=MAX(MAX(a1,a2),a3)" but when I try to pull that equation down
the column it will not provide a value higher than the A3 value. Is there a
way to do this?

Thanks,

Bob

 

[Dave Peterson]

First, your formula is the same as:

=max(a1,a2,a3)
or
=max(a1:A3)

And double check to see if you have calculation set for automatic:
tools|options|calculation tab

 

[BobB]

I solved the problem by fooling the code. I set a1 and a2 to 0.0 to
calculate a3 as 0.0. Then I copied the equation down the column getting
correct answers and finally I re-input a1 and a2 correctly. It works.