I need to know the highest price I have ever paid for a product. In my
inventory, I update prices monthly, changing the previously recorded price.
If the "new price" is more than the price recorded in the "high price"
column, I want that price to change to the "new Price" amount. I have tried
using the MAX formula in conjunction with the IF formula, but it is not
working properly because if the "New Price" is in between the two prices, it
records that "new price". Any suggestions? Note: I am pretty much a novice
at this so please try to keep it simple.