Forum Discussion
- Delete cell content based on a condition -
Hello, 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 > 0 , then I want to delet whatever is written in the cell A1...
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.