Hi,

Here's the example:
Month Inv Sales FC
Jan 350 50 3.5
Feb 300 100 2.5
Mar 200 150 1.5
Apr 50 100 0.5
May -50

Hope it is clear!

Thanks.



"Ashish Mathur" wrote:

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!