Inventory Management

[Than Htaik]

Hi, Dear all,

I would like to ask a simple problem what I'm facing .
There are three columns , Stock Balance(A),Excess Stock(B) and Average Consumption(C).
They words in inverted comma are outputs I want.
Check this
A B C
1 =0 =0 =0 "Not Using"
2 >0 >0 >0 "=B3/C3"
3 =0 =0 >0 "Stock Out"
5 >0 >0 =0 "Dead Stock"


Could you please have a look and suggest the suitable formula for me

Regards,

 

[Andrew Poulsom]

Welcome to MrExcel.

How about?

=IF(AND(A1=0,B1=0,C1=0),"Not Using",IF(AND(A1>0,B1>0,C1>0),B3/C3,IF(AND(A1=0,B1=0,C1>0),"Stock Out",IF(AND(A1>0,B1>0,C1=0),"Dead Stock"))))

 

[Than Htaik]

Thanks for your help, Andrew.