C
Chuck
This is driving me crazy! I want to set the value of
cell A2 to A1 when A1 > A2, i.e., I want to save the
largest value of A1 in A2. But I get a circular
reference error if I enter =IF(A1>A2,A1,A2)in cell A2.
Or I get a value of TRUE if I enter =IF(A1>A2,A1)in A2.
What I rally want is a function that will leave the
contents of A2 unchaged if A1 is not greater that A2.
Thanks,
Chuck
cell A2 to A1 when A1 > A2, i.e., I want to save the
largest value of A1 in A2. But I get a circular
reference error if I enter =IF(A1>A2,A1,A2)in cell A2.
Or I get a value of TRUE if I enter =IF(A1>A2,A1)in A2.
What I rally want is a function that will leave the
contents of A2 unchaged if A1 is not greater that A2.
Thanks,
Chuck