Hi,
Can someone help me on what formula to use in cell L13
I am forecasting the amount of claim to be allocated on cell L13 based on the percentages from cell B2 to B8. And that amount should show under columns L13 onwards.
Basically it is a weekly forecasting.
It goes like, if E13 is within the date range of L13 then multiply C13 by B2, or if its F13 that is within the date range of L13, then multiply C13 by B3 instead and so on and so forth.
I tried to create a formula, unfortunately it wont work.
I just want the apportioned claim amount to show under the week the type of claim falls due.
I hope I made it clear. Please help. Thank you!
See attached file.
Bookmarks