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 wrote:
>
> 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

[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.


"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:433DAF1E.F22DD234@verizonXSPAM.net...
> 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 wrote:
>>
>> 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