J John Apr 27, 2004 #1 I have this forumla =EXACT(AA6,AB6) However, i want it to also look in cell AC6 How?
F Frank Kabel Apr 27, 2004 #2 Hi so you want to check that all three cells are identical? If yes try =AND(EXACT(AA6,AB6),EXACT(AA6,AC6))
Hi so you want to check that all three cells are identical? If yes try =AND(EXACT(AA6,AB6),EXACT(AA6,AC6))
P Peter Atherton Apr 28, 2004 #3 -----Original Message----- I have this forumla =EXACT(AA6,AB6) However, i want it to also look in cell AC6 Click to expand... John try this =IF(AND(EXACT(AA6,AB6),EXACT(AB6,AC6)),TRUE,FALSE) Regards Peter
-----Original Message----- I have this forumla =EXACT(AA6,AB6) However, i want it to also look in cell AC6 Click to expand... John try this =IF(AND(EXACT(AA6,AB6),EXACT(AB6,AC6)),TRUE,FALSE) Regards Peter
