MrExcel Publishing
Your One Stop for Excel Tips & Solutions

If 3 Text Cells are the same make the cell = 1


Posted by Lewis on April 19, 2001 6:11 PM

Hey all, trying to get 3 cells to cross check each other. If cell 1 = cell2 = cell3 then the active cell =1 else 0

does anyone know how to make that formula I figured it out if the cells had numaric data but I can't seem to get it to work with text data

thanks in advance...

please e-mail tod.b@home.com

thanx


Posted by Jim on April 19, 2001 9:08 PM


How about this: cells to be cross-checked are B1, C1 and D1

=IF(B1=C1,IF(C1=D1,1,0),0)

or

=IF((AND(B1=C1, C1=D1)),1,0)