I don't really know how to word this....for cells with formulas, I know how to do this.
Ex. You have a formula in cell B2...you want B2 to return a blank if A2 is blank
Syntax for formula in B2 would begin as follows
=IF(A2="","",
Now, pretend that B2 has a data validation list. I enter data in A2 and select an option in B2. I then decide to delete the info in A2. After deleting the data from A2, I want B2 to return a blank. How do I do this?
I'm ready to pull my hair out, so thanks in advance.
~Sandy
Bookmarks