I'm trying to calculate the number of weeks cover an inventory value
represents. My worksheet is laid out as follows:
Each Row represents a week
Col A Col B Col C
W/ending Inv Demand Qty Weeks Cover
1095 44 15.1
1046 64 14.3
984 62 13.3
922 62
863 59
806 57
1019 57
962 57
1034 72
939 95
844 95
750 94
656 94
593 63
514 79
435 79
357 78
265 92

The values in the weeks cover (Col C) need to be a calculation based on the
value in column A using the demand from column B to work out how many weeks
the on hand inventory will last.
The first 3 values are what I expect the function to return in these cells.
I assume this will require an array and to be honest I'm struggling with the
logic.
Can anyone help me with the correct function to calculated this.