Hi
I have 5 cells that will be populated with the test "Yes" or "No" (M4:Q4). I would like N4 to return "Yes" if all the other cells have "yes" and "no" if there is one or more that has "No".
Can anyone provide a solution?
Thanks
T
Hi
I have 5 cells that will be populated with the test "Yes" or "No" (M4:Q4). I would like N4 to return "Yes" if all the other cells have "yes" and "no" if there is one or more that has "No".
Can anyone provide a solution?
Thanks
T
Perhaps
=IF(ISERROR(MATCH("No",M4:Q4,0)),"Yes","No")
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks