PC Review


Reply
Thread Tools Rate Thread

Comparing contents in three cells

 
 
gcotterl
Guest
Posts: n/a
 
      10th Sep 2010
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?


 
Reply With Quote
 
 
 
 
zvkmpw
Guest
Posts: n/a
 
      10th Sep 2010
> How can verify whether the contents of B1, D1 and F1 are identical?

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

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:09 AM.