Forum

Notifications
Clear all

cal stock

8 Posts
3 Users
0 Reactions
75 Views
(@meytithveasna)
Posts: 70
Estimable Member
Topic starter
 

Hi Guru,

if the stock value is less than 50% of the quantity value the status should be "LIMITED STOCK"
but if the stock value is more than 50% of the quantity value the status should be "STOCK OK".

Note Quantity in B3 &Stock in D3

 

TIA

 
Posted : 15/08/2017 4:06 am
(@sunnykow)
Posts: 1417
Noble Member
 

Try this

=IF(D3<(B3*0.5),"LIMITED STOCK","STOCK OK")

 
Posted : 15/08/2017 4:54 am
(@meytithveasna)
Posts: 70
Estimable Member
Topic starter
 

ThanksSunny

I have anther problem

based on active days in column A

I want to code those <=90days as "active",>90days as "dormant" and empty cell as "dormant",

similarly i want to code status in column B like inquiry and referral as  "lead ",pitching and pricing as warm,negotiation as hot,deal closed as customer ,rejected and no response as cold,

 
Posted : 15/08/2017 7:19 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Mey

That is a lot of questions.

Please attach a sample file with the data and the expected results.

 
Posted : 15/08/2017 10:21 am
(@meytithveasna)
Posts: 70
Estimable Member
Topic starter
 

ok

 
Posted : 16/08/2017 12:29 am
(@meytithveasna)
Posts: 70
Estimable Member
Topic starter
 

Here is attached file

 
Posted : 16/08/2017 12:42 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Mey

See attachment.

Sunny

 
Posted : 16/08/2017 2:28 am
(@mynda)
Posts: 4762
Member Admin
 

Hi Mey,

Here are some tutorials on the solutions provided by Sunny that will help you answer these questions yourself going forward:

IF and OR, IF and AND

VLOOKUP

Also, in future please start a new thread for a new question.

Thanks,

Mynda

 
Posted : 17/08/2017 3:01 am
Share: