How to check for and replace the largest number in excel
 

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 (a2a3,A2,a3)

How to check for and replace the largest number in excel
 

Hi!

A2 would have to start out as an empty cell.

Goto ToolsOptionsCalculation
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 wrote in message
...
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 (a2a3,A2,a3)