cfhasan1
asked on
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
Try this:
=IF(AND(OR(C1="No",C2="No" ),C3="Loan ",C4="*XYZ *"),"TDDL" ,"TDL")
=IF(AND(OR(C1="No",C2="No"
ASKER
Both Solutions are close, but I want fields to be blank if C3 does Not equal LOAN
Try this...
=IF(C3="LOAN",IF(AND(OR(C1 ="No",C2=" No"),COUNT IF(C4,"*XY Z*")),"TDD L","TDL"), "")
=IF(C3="LOAN",IF(AND(OR(C1
ASKER
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?
I used a variation of the formula as follows:
=IF(S2="LOAN",IF(AND(OR(Q2
Problem is I discovered another string text to account for , how do modify and add CIF to the search?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
In box me of how I should have asked the question, please or email cfhasan1@aol.com
ASKER
Perfect!
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. :)
Glad it worked as desired in the end. :)
ASKER
Understood and appreciate the feedback
Open in new window