I'm using an Excel spreadsheet with multiple pick from list cells to calculate a text value (based on a weighted numbering in adjacent cells). I need to evaluate C2:C11 such that if any cell is null, C12 reads "Select a Value for Each Concept." Once all cells have been filled, I then need to display the text I am currently displaying with the following statement.
=IF(D12<=30, "Every Five Years", IF(D12<=60, "Every Three Years", IF(D12>60, "Every Year")))
Any thoughts on accomplishing?