mey tithveasna
Member
Members
Forum Posts: 71
Member Since:
March 5, 2017
March 5, 2017
Offline
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
SunnyKow
Puchong, Malaysia
VIP
Members
Trusted Members
Trusted Members
Forum Posts: 1432
Member Since:
June 25, 2016
June 25, 2016
Offline
mey tithveasna
Member
Members
Forum Posts: 71
Member Since:
March 5, 2017
March 5, 2017
Offline
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,
SunnyKow
Puchong, Malaysia
VIP
Members
Trusted Members
Trusted Members
Forum Posts: 1432
Member Since:
June 25, 2016
June 25, 2016
Offline
SunnyKow
Puchong, Malaysia
VIP
Members
Trusted Members
Trusted Members
Forum Posts: 1432
Member Since:
June 25, 2016
June 25, 2016
Offline
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Dirk Veeken, Stephanie Phillips, Jorge Chicas
Guest(s) 9
Top Posters:
Catalin Bombea: 1909
SunnyKow: 1432
Anders Sehlstedt: 899
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 279
lea cohen: 245
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Sheila Sanders
Francine Walshe
Sean Ladlow
Jorge Chicas
mahmoud salem
Irvine Choolo
Deon Bouwer
Amgad Squires
jim bo
Linda Bock
Forum Stats:
Groups: 3
Forums: 24
Topics: 6836
Posts: 29985
Member Stats:
Guest Posters: 49
Members: 33568
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —