Jul 28 2022 12:58 PM
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
Jul 28 2022 02:05 PM
SolutionHi @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.
Jul 28 2022 02:11 PM
Jul 28 2022 02:05 PM
SolutionHi @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.