First off, forgive me for any incorrect terminology here, I've been trying to figure this out...but I'm fairly new to all this.

I'm working on a project where I'm using data validation to make little yes/no drop-down menus. For example

Has Material been received? (yes/no) <-- lets say thats cells B1 & B2

So the next question in C1 is 'When is material due?' I'd like to make an if/then statement so if they answer yes in cell B2, then the next question is automatically filled in with "N/A"


Hope that makes sense...please help!