Hello
I have a forecast for remainder of financial year. How would I create a if argument that if we are in the current "Period", do not add growth percentage but a forecast for a future "Period" should be forecast plus growth for that relevant Period (row 5 in Forecast tab) and country (in col A in Forecast tab). Both the Forecast and Assumptions tabs have dates as well as Periods, if that makes it easier to map a argument
I want the results to occur in the Forecast tab. The growth data is in the Assumptions tab.
(My original workbook, the Forecast tab pulls in data in a not-so-simple manner from accounting system-driven data tab but for this thread, I've just done this simple layout for now)
thanks
Bookmarks