I am trying to write a formula that updates a number in the cell if another cell is empty, and leaves the last number calculated if the other cell is not empty. I am calculating my profit, which changes until I actually collect it, because my AMOUNT SPENT is a dollar value calculated from a price and quantity of bitcoin. So far I have this:
Where C2 is AMOUNT RECEIVED and H2 is AMOUNT SPENT i.e.
|AMOUNT RECEIVED||AMOUNT SPENT||PROFIT|
|400||350||Amount received - amount spent|
K2 is another cell somewhere that acts as a true/false mechanism. If it is not empty, that means I have collected the profit and it no longer varies (the amount spent is Bitcoin price x amount of bitcoin spent) so my profit changes until I convert between currencies. There is probably another way of going about this that I am too inexperienced to see. Sorry for any clarity issues, I am not great with this stuff.