- Delete cell content based on a condition -

Question

Hello,&nbsp;is there an easy way to delete the content of one cell based on the content of another cell?For example, if cell A2 content is &gt; 0 , then I want to delet&nbsp;whatever is written in the cell A1.&nbsp;&nbsp;Thank you so much in advance!

mathetes · Answer

sarafiore&nbsp;&nbsp;An "easy way"? Probably not without a macro of some sort.&nbsp;Why don't you give a more complete description of what the overall task is, of which that step is just a part. It may be that there is another approach altogether that would accomplish the bigger objective.

twifoo · Answer

sarafiore&nbsp;Perhaps, the formula you need in A2 will be as shown below:&nbsp;

sarafiore · Answer

mathetes&nbsp;I'll try to explain it in the simplest way and I've attached a screenshot for better understanding 🙂&nbsp;The column "Missing Mat" is the sum of the goods bought or sold in a week&nbsp;and it is calculated through a simple +SUM function.&nbsp;When stocks go negative, the "Status" column tells me that it is necessary to place a new order for goods: when the&nbsp;"Missing Mat" cell goes negative, the&nbsp;"Status" cell displays the wording "TO ORDER".&nbsp;To remind me that I placed the order,&nbsp;I write an asterisk next to it.&nbsp;&nbsp;The "Status" column is in fact calculated&nbsp;through the +IF function:&nbsp;+IF(Missing Mat&lt;0; and +IF(there is an asterisk, then print "TO ORDER"; if false print "ORDERED"),&nbsp;so that "ORDERED" appears after I write an asterisk.------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;+IF(C3&lt;0;+IF(B3="*";"TO ORDER";"ORDERED");"")&nbsp; &nbsp;&nbsp; &nbsp;------&nbsp;What I need is that&nbsp;when the "Missing Mat" cell returns to 0, because I have received the order, the cell containing the asterisk is automatically deleted...&nbsp;I would be very very very grateful for any help!&nbsp;Thanks in advance.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

sarafiore · Answer

Twifoo&nbsp;Thank you very much for your help!I tried with your formula but the problem still persists...when the "Missing Mat"&nbsp;cell is back to 0&nbsp;(it changes automatically because it is a summation), I need the&nbsp;cell containing the asterisk to be automatically deleted, if not when the&nbsp;"Missing Mat"&nbsp;cell&nbsp;will go negative again,&nbsp;the asterisk remains and gives me "ORDERED"&nbsp;when it is not ordered yet.&nbsp;

twifoo · Answer

sarafiore&nbsp;We cannot delete the contents of another cell through formulas. Perhaps, VBA can but it is not my forte.

Forum Discussion

- Delete cell content based on a condition -

6 Replies

Resources