i want to ad another AND condition to this if someone can help

[censura]

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

 

[jasonb75]

=IF(OR(M2="Not Interested",M2="Failed Credit Check",AD2="Loan Only"),"N/A",IF(AE2="Loan Plus Accountancy",O2,""))

 

[censura]

=IF(OR(M2="Not Interested",M2="Failed Credit Check",AD2="Loan Only"),"N/A",IF(AE2="Loan Plus Accountancy",O2,""))

Thank you works