Comparing contents in three cells

's Computer Specifications

B1, D1 and F1 contain alphanumeric data. For example:

123456789-1

A1 contains this formula:

=IF(B1=D1=F1,"YES","NO")

But "NO" is displayed in A1

How can verify whether the contents of B1, D1 and F1 are identical?

's Computer Specifications

> How can verify whether the contents of B1, D1 and F1 are identical?

One way:
=IF(AND(B1=D1,B1=F1),"YES","NO")

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing contents in three cells	gcotterl	Microsoft Excel Worksheet Functions	0	10th Sep 2010 01:36 AM
Comparing Text Contents of Cells	Keith Norris	Microsoft Excel Programming	4	16th Dec 2008 03:50 PM
Comparing cell contents with different reference cells	Martin B	Microsoft Excel Worksheet Functions	3	22nd Nov 2006 07:10 PM
Comparing local contents to web server contents	AAJ	Microsoft Dot NET	0	5th Oct 2006 07:51 AM
Comparing contents - is it possible	Lynn A.	Microsoft Excel Programming	10	16th Sep 2004 10:48 AM