I have a cell (A1) that will be changed over time. If a certain condition is met I want the current value of A1 to be copied to for example B1. But I don’t want B1 to change when A1 is changed again.
So for example:
=IF(A1 > 5, value of A1, “-”)
I have a few cells with different conditions so the value of A1 will be saved at multiple instances.
Hope this is clear enough.