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!
Bookmarks