I have a validation list from cells D12 - D20 which means I can select from Yes, No or NA
I want cell D21 to read the answers selected in these cells and then put Yes or No in cell D21.
Example: if all of the cells from D12-D20 read as No - cell D21 = No, if ANY cells from D12-D20 are Yes I want D21 to read Yes?
I cannot find out how to do this?????
Bookmarks