• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

true or false based on two corresponding cell formula value

aligahk06

New Member
Dear All,

Thanks a lot for helping us previous threads.
I have a result sheet , i want to return true or false cell by cell .
e,g- in result sheet C4 and C5 match then cell C6 TRUE , then D4 and D5 match then result in d6 true if match and false if not match and so on for E4 and E5 upto AG4 and AG5.
Note - Match with formula return value.

Attached sheet...

rgds,
aligahk06
 

Attachments

vletm

Excel Ninja
aligahk06
Isn't this fourth version from same?
You had already many solutions!
=if(C4=C5,true,false)

... You should start to follow Forum Rules.
 

aligahk06

New Member
Sir,
thanks for precious time , i applied that formula but it is giving false in C6 but C4 and C5 data is same . it must return true.?
That's why i posted this question to forum...
C4=day off
C5=day off
 

vletm

Excel Ninja
aligahk06
1) Did You read Forum Rules as I've asked to do many times?

2) As written in above reply, Your files Day Off's are different as You could see with Your own eyes - snapshot below:
Screenshot 2019-09-09 at 17.51.13.png
3) I gave already reply to this in Your previous version of this thread, which take care those cases.

What would Your point to ask same things many times in many forums?
You should 'think' to hire someone, then You'll notice, what are You doing!
 
Top