Hi hope you can help i have this formula
=IF(OR(M2="Not Interested",M2="Failed Credit Check",AD2="Loan Only"),"N/A",O2)
So what i am trying to achieve is have these 3 conditions in the one formula
1) If M2 is one of: Not Interested , Failed Credit Check or AD2 is Loan Only it assigns value N/A (as it currently works)
2) If AD2 = Loan Plus Accountancy AND M2 = "NO" assign "NO" (new condition)
3 If the outcome is neither N/A or NO leave AE cell blank
Thank you
=IF(OR(M2="Not Interested",M2="Failed Credit Check",AD2="Loan Only"),"N/A",O2)
So what i am trying to achieve is have these 3 conditions in the one formula
1) If M2 is one of: Not Interested , Failed Credit Check or AD2 is Loan Only it assigns value N/A (as it currently works)
2) If AD2 = Loan Plus Accountancy AND M2 = "NO" assign "NO" (new condition)
3 If the outcome is neither N/A or NO leave AE cell blank
Thank you
Last edited: