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

Formula to mark if multiple conditions are met

M

MnhPhm

New Member
http://tinypic.com/r/w9wdqo/5


I want to know when the same customer buys at different stores on the same date. I used an if formula as follows but it didn't seem to work:


=IF(A2=A3&D2=D3,IF(C2=C3,"","X"),"")


Any advice/help is much appreciated. Thanks.
 
not sure I'm following youre formula properly... can you explain what you want it to do?


first attempt:

IF(AND(a2=a3,d2=d3),IF(c2=c3,"","X"),"")
 
I actually found a way around it, the original approach was too long-winded. Thanks for giving it a try anyway. I'm still a beginner in Excel so sometimes things that make sense in my head don't quite make sense to others
 
Hi, Wim!


In your formula this part "A2=A3&D2=D3" evaluates to a concatenation of 2 logical values, so it'd result in TRUETRUE, TRUEFALSE, FALSETRUE, FALSEFALSE values.


In Jason's formula that fixed part "AND(A2=A3,D2=D3)" evaluates to an AND condition between to logical values, so it'd result in "AND(TRUE,TRUE)", "AND(TRUE,FALSE)", "AND(FALSE,TRUE)", "AND(FALSE,FALSE)" values, that's to say TRUE, FALSE, FALSE, FALSE.


Hope it helps.


Regards!
 
You must log in or register to reply here.
Back
Top