Formula to clear out cells with in a spread sheet if certain input entered.

**sp1974** · 06-23-2009, 10:53 AM

Hello. On the attached spread sheet here is what I am trying to do. In B2 I will either enter D (digital label) or F (Flexo label). With that than if a D is entered nothing else will happen with in spread sheet but if F is entered D23:Q40 will need to be cleared out and blank. Can someone help with a formula to achieve this?

**NBVC** · 06-23-2009, 10:54 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**sp1974** · 06-23-2009, 11:36 AM

Is that title good?

**ChemistB** · 06-23-2009, 11:42 AM

You can either have VBA code looking at B2 and clearing D23:Q30 if B2 is "F" or you can modify your equations in D23:Q30 with an OR statement like this in D23 for example

Please Login or Register  to view this content.

Does that work for you?

**sp1974** · 06-23-2009, 11:49 AM

I will try to edit each formula what portion would I need to add to each of the different formulas I have. Just the =IF(OR(D$18="",B2="F") at the beginning?