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
Try this
=IF(D3<(B3*0.5),"LIMITED STOCK","STOCK OK")
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,
Hi Mey
That is a lot of questions.
Please attach a sample file with the data and the expected results.
ok
Here is attached file
Hi Mey
See attachment.
Sunny
Hi Mey,
Here are some tutorials on the solutions provided by Sunny that will help you answer these questions yourself going forward:
Also, in future please start a new thread for a new question.
Thanks,
Mynda