Forum Discussion
Adamj2022
Jul 28, 2022Copper Contributor
Forecast
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
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.
2 Replies
- Adamj2022Copper ContributorI think that will work, I’ll give it a try.
Much appreciated thank you very much