Excel Formula with Multiple Criteria

I need a formula check if a Column C1 or C2 = “No” & C3= “LOAN” & C4 contain “XYZ” if yes then TDDL , if no TDL and all other cells blank
cfhasan1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Based on your description...

=IF(AND(OR(C1="No",C2="No"),C3="LOAN",C4="XYZ"),"TDDL","TDL")

Open in new window

0
 
Rob HensonFinance AnalystCommented:
Try this:
=IF(AND(OR(C1="No",C2="No"),C3="Loan",C4="*XYZ*"),"TDDL","TDL")
0
 
cfhasan1Author Commented:
Both Solutions are close, but I want fields to be blank if C3 does Not equal LOAN
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Try this...

=IF(C3="LOAN",IF(AND(OR(C1="No",C2="No"),COUNTIF(C4,"*XYZ*")),"TDDL","TDL"),"")
0
 
cfhasan1Author Commented:
Neeraj,
I used a variation of the formula as follows:
=IF(S2="LOAN",IF(AND(OR(Q2="No",R2="No", IFERROR(SEARCH("PDM", P2),0)=0),"TDDL","TDL"),"")

Problem is I discovered another string text to account for , how do modify and add CIF to the search?
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
This is not a right way of asking a question.

Your existing formula isn't clear enough to tell what exactly you are trying to achieve.

BTW give this a try and tweak it as per your requirement.

=IF(S2="LOAN",IF(AND(OR(Q2="No",R2="No"),OR(ISNUMBER(SEARCH({"CIF","PDM"}, P2)))),"TDDL","TDL"),"")

Open in new window

1

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
cfhasan1Author Commented:
In box me of how I should have asked the question, please or email cfhasan1@aol.com
0
 
cfhasan1Author Commented:
Perfect!
1
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
What I meant, you changed the cell references as well as the criteria. These formulas specially with multiple criteria and without having a sample workbook are tricky one to derive sometimes. You should finalize your question before asking it. That's it. :)

Glad it worked as desired in the end. :)
0
 
cfhasan1Author Commented:
Understood and appreciate the feedback
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.