IF AND Formula

Hello all, I am trying to complete an IF AND statement for the following problem (new to excel, somewhat a one time project! 

I have 6 wells. Their names are 10,11,14,15,16 and 17. I need to have a True statement of “Oil Drip:” returned when wells 10,11,14 and 15 are selected within a dropdown list in cell b11 but only when “ON” is selected from a dropdown list in cell b19. When all other wells (16 and 17) within b11, or when “OFF” is selected from b19, a false statement that provides an empty cell is needed. I would really like the cell highlighted in color for the True statement as well. PLEASE HELP! 

Thank you very much in advance for anyone’s time! 


By: Mark

Leave a Reply

Your email address will not be published. Required fields are marked *