software

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

Hi!

A2 would have to start out as an empty cell.

Goto Toolsgt;Optionsgt;Calculation
Check Iteration

Then enter this formula in A2:

=MAX(A2,A3)

NB: there is no quot;audit trailquot; 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

quot;Navigation Manquot; lt;Navigation gt; wrote in message
news
gt; In Excel 2003 how do you check two cell for the largest numnber, then
gt; replace the existing one if true, without invoking the circular referance
gt; error.
gt;
gt; for cell a2 if (a2gt;a3,A2,a3)