I cannot understand why a cell B1 returns 0 when I refresh the sheet.
I get a daily share price from the internet. That share price is in cell a1. I track the share price on a daily basis, however, I want to record its highest price throughout the year. the formula i use is
=MAX(A1:B1)
However, if A1 has £6.45 when I refresh B1 will only return 0. I've checked the formatting of each cell, I even tried using the following: =IF($Y$1,0,MAX(A1:B1)) with 0 in Y1
I'm baffled
Thank you
Dave
Bookmarks