|Hello - I created a spreadsheet to track my stocks profit. The spreadsheet contains a cell (A1) which sums all the stocks' current profit. This cell changes (up or down) daily depending on the stock market.|
How do I create a separate cell (B1) which shows the maximum historical profit ever found in A1? For example, if A1 starts at $1,000, then B1 should be $1,000. If A1 increases to $1,500, then B1 should also change to $1,500. But, if A1 drops below $1,500, then B1 should REMAIN at $1,500.