How to check for and replace the largest number in excel

[Navigation Man]

In Excel 2003 how do you check two cell for the largest numnber, then
replace the existing one if true, without invoking the circular referance
error.

for cell a2 if (a2>a3,A2,a3)

[Biff]

Hi!

A2 would have to start out as an empty cell.

Goto Tools>Options>Calculation
Check Iteration

Then enter this formula in A2:

=MAX(A2,A3)

NB: there is no "audit trail" to follow, so if you make a
mistake..............you enter 1000 in A3 when you meant to enter 100.

You'd probably be better off using an event change macro that records the
value every time it changes in cell A3. Then you'd have an audit trail.

Biff

"Navigation Man" <Navigation [email protected]> wrote in message
news:[email protected]...
> In Excel 2003 how do you check two cell for the largest numnber, then
> replace the existing one if true, without invoking the circular referance
> error.
>
> for cell a2 if (a2>a3,A2,a3)