IF/THEN:Make multiple cells read N/A or remain fillable depending on 1 other cell dropdown

Hi,

I need to use the IF/THEN argument but NOT fill that argument into the cells I need to obey it.

See attached excel sheet with comment...it will be very clear what I'm asking.

I have a YES/NO drop down menu in E8. The question to be answered by the drop down: Was this analysis required?

If yes, I need all related cells to that analysis (non-sequential and highlighted on attached sheet) to remain blank and fillable for data entry. If "No" is selected from the drop down, I need all of those (non-sequential) highlighted cells to auto fill with N/A.

Can anyone help with this?

Thanks!