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 ...
BI & Data Analysis
excel
Formulas and Functions
  • dscheikey's avatar
    dscheikey
    Jul 28, 2022

    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.

     

dscheikey's avatar
dscheikey
Bronze Contributor
Jul 28, 2022

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
    Jul 28, 2022
    I think that will work, I’ll give it a try.

    Much appreciated thank you very much