Forecast

[Adamj2022]

Hi all 

Any help would be appreciated, I currently have a forecast for a yearly budget that adjusts week by week. Is it possible to create a cell that records the high point of this forecast. So at the end of the year I can see how much we saved compared to what the high end of the forecast was projecting to prove what we but in place worked ? 

I hope that makes sense to someone hahaha

Many thanks Adam

[#2 · Accepted solution]

Hi @Adamj2022,

I have created a small example document for you. I have solved this with a simple IF query that simply displays the value of the current cell again if the current result is not greater.

In Excel Desktop, iteration must be switched on in the options.

[#3]

I think that will work, I’ll give it a try.

Much appreciated thank you very much