Search code examples
excelcell

Excel IF a cell value is bigger then previous value of the same cell

I would like to put a value to A1 and when I changed A1 I want to keep the first entered value in another cell.

Would that be possible ?

Thanks

Solution

  • Here is a solution using formulas, only. It requires that you switch the iterative calculations on in Excel options. You can set it to 1 iteration.

    You only need to enter the following formula into B1:

    =IF(ISBLANK(C1),IF(ISBLANK(A1),B1,IF(B1="",A1,B1)),"")

    A1 is the cell whose value is to be remembered, B1 is the memory location, C1 is the reset button.

    • As long as C1 is empty, B1 holds the very first value entered into A1.
    • When you enter any value in C1, B1 becomes empty and blocked in this state.
    • You can then delete the content of C1, and B1 will become responsive again. It will "catch" the first value present A1 and keep it until you reset it again.