Some values should be in 'Offset Volumes for 1st Forecast Year' line, but nothing!
Where am I doing wrong?
Go to Solution.
The OFFSET function is working with the -52 Volumes. So if you go to FY20 you will see your results.
View solution in original post
@Markcol The IF formula you are using refers to the 1st forceast year, which in this case is FY20; if you scroll across to this time period you will see the data. Thank You