excel - How to check if a cell that contains text matches two other cells? -
i'm matching names of students scores. example:
b c d e f g 1 adam 10 adam 8.5 adam 9 ok 2 luke 10 luke 9 john 9 false 3 john 9 john 8 luke 10 false 4 lucy 8.5 lucy 9 lucy 8 ok
columns , b names , scores mathematics.
columns c , d names , scores english.
columns e , f names , scores history.
i need formula check if a1, c1, , e1 contain same text , if fill g1 ok
.
if 1 of them different, g1 should show false
.
you can use if , and function:
=if(and(b2=d2,d2=f2),"ok","false")
in case 3 name in b2, d2 , f2.