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?
|