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.


Popular posts from this blog