So if all have to "Pass" to get an "Ok", then maybe this formula?
=IF(COUNTIF(A2:H2,"Pass")=COUNTA(A2:H2)/2,"Ok","Review")
So if all have to "Pass" to get an "Ok", then maybe this formula?
=IF(COUNTIF(A2:H2,"Pass")=COUNTA(A2:H2)/2,"Ok","Review")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks