User Profile
sarafiore
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: - Delete cell content based on a condition -
Twifoo Thank you very much for your help! I tried with your formula but the problem still persists...when the "Missing Mat" cell is back to 0 (it changes automatically because it is a summation), I need the cell containing the asterisk to be automatically deleted, if not when the "Missing Mat" cell will go negative again, the asterisk remains and gives me "ORDERED" when it is not ordered yet.92KViews0likes2CommentsRe: - Delete cell content based on a condition -
mathetes I'll try to explain it in the simplest way and I've attached a screenshot for better understanding 🙂 The column "Missing Mat" is the sum of the goods bought or sold in a week and it is calculated through a simple +SUM function. When stocks go negative, the "Status" column tells me that it is necessary to place a new order for goods: when the "Missing Mat" cell goes negative, the "Status" cell displays the wording "TO ORDER". To remind me that I placed the order, I write an asterisk next to it. The "Status" column is in fact calculated through the +IF function: +IF(Missing Mat<0; and +IF(there is an asterisk, then print "TO ORDER"; if false print "ORDERED"), so that "ORDERED" appears after I write an asterisk. ------ +IF(C3<0;+IF(B3="*";"TO ORDER";"ORDERED");"") ------ What I need is that when the "Missing Mat" cell returns to 0, because I have received the order, the cell containing the asterisk is automatically deleted... I would be very very very grateful for any help! Thanks in advance.91KViews0likes4Comments
Recent Blog Articles
No content to show