=EXACT

F

Frank Kabel

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

-----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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need formula to I have too many nested level 3
Sum Duplicates in Groups 2
Sum Duplicates without Sorting 3
Excel 2007 - AVERAGEIF on rows that are non-continuous 2
countif function possibility? 2
Formula Result is "V6", need Excel to use cell "V6", not the resul 3
Excel 2007 formula help 1
leftmost number value 1

Top