Hi all,
Am in need of a bit of help with a formula. The formula needs look at the depot cover and calculate the forward forecast. So if depot cover is:
less than or equal to 1 - then it needs to add weeks 34,35,36 and 37.
greater than 1 but, less than or equal to 2 - then add weeks 35, 36, 37
greater than 2 but, less than or equal to 3 - then add weeks 36 and 37
greater than 3 but, lets than or equal to 4 - then = week 37
greater than 4 = 0
Attachment 419148
Hope that makes sense
TIA
Bookmarks