Cell A4: =IF(A1A2,TODAY(),"") ????

--

HTH

RP
(remove nothere from the email address if mailing direct)


"rtbrd" wrote in message
...
Maybe I should clarify the situation.

Cell A1 contains a value that will change with caculations in the sheet,
this may occur multiple times a day.

Cell A2 contains the reference value for checking if the calculated value
is
above this reference.

Cell A3 contains the formula: =IF(A1A2,A1,A2), this will record the
maxium
value (true) or reference (false).

Cell A4 contains the formula: =IF(A1A2,TODAY(),), this will record the
date
of the maximum value but it the formula evaluates as false the previous
maximum date is replaced.

Is there a way to create a formula that will do nothing if it evaluates to
false? I need to find a way to freeze the date that the maximum value
occurred. I would like to automate this. I realize that I can copy and
paste the value in but I would prefer it to be automated.







"rtbrd" wrote:

I am tracking a value that will vary by day. I want to record and save
the
date on which the max occurred. Example: If maximum, then record date,
if
not maximum leave previous date.

Can I create an If statement that does nothing to the cell if the result
is
false?