Stock Coverage

[Swaski]

Hi all,

Need help with what seems like a simple formula but couldn't figure it out.

SETUP
A column: product
B column: sales weekly
C column: Inventory total
D column: stock coverage per week

(D)column will calculate how many weeks (C)column can cover based on (B)column sales.

Problem when sales is zero, the return comes back as "#DIV/0".

Thanks in advance.

[spitfireblue]

Hi Swaski,

The error is saying that you cannot divide by zero, which is correct because you have x amount of stock but you are not selling any therefore your cover is infinity!
If you don't want to show the error you can use a formula like this, which will put a blank space instead of "#DIV/0"

Please Login or Register  to view this content.

[Swaski]

Thanks for the reply but since I still have inventory, even though no sales, it should display how many weeks my inventory can cover, not zero.

[spitfireblue]

Your weeks cover is infinity. Maybe you could change your formula to something like this?

Please Login or Register  to view this content.

[Swaski]

@spitfireblue Thanks! I will use infinite for such results. However, if I have zero sales AND zero stock, the outcome is also infinite, shouldn't it be zero instead which helps trigger replenishment?

[spitfireblue]

You can ammend your formula like this...

Please Login or Register  to view this content.