Hi everyone,
Apologies I'm new to this forum and an excel rookie.
I'm trying to find the highest price of a continually updated input.
The function in words is: if today's price is greater than yesterday's price, replace with today's.
The issue I'm having is twofold:
1) While, the input is constantly changing, I need to manually input a starting high price, which can be used as a 'base' to be compared to the continually changing input until the changing input moves beyond this 'base'.
2) While using a simple IF function I can replace this manually inputed 'base' high price when the constantly changing input is greater than the 'base' price; but then I don't know how to lock that new high in before it changes. I need the new high to be locked into a cell until it is usurped by a higher price.
I hope that is sort of clear.
Thank you so much.
Have a great day everyone.
Kind Regards,
Tom
Bookmarks