Forum Discussion

Adamj2022's avatar
Adamj2022
Copper Contributor
Jul 28, 2022
Solved

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

  • dscheikey's avatar
    dscheikey
    Bronze Contributor

    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.

     

    • Adamj2022's avatar
      Adamj2022
      Copper Contributor
      I think that will work, I’ll give it a try.

      Much appreciated thank you very much