View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
neocuproine neocuproine is offline
external usenet poster
 
Posts: 2
Default Forward Cover in Inventory

Hi everybody,

I am stuck in finding a smooth way of calculating forward covers in
inventory figures. Let me explain:
I have Monthly Inventories in column A, Sales in column B and Forward Cover
in column C
The inventory in A2 is A1 - B1; A3 = A2-B2;...
The Forward Cover should indicate at each month the months of Inventories I
have left until I turn negative...

Can someone please help?`

Thank you!