Hi,

Could you post an example please.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"neocuproine" wrote in message
...
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!