Assistance for the IF Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to test the condition of Cell A1 for either/or and B1 for
either/or and if C1 is true, display the value of D1

=(IF(OR(A1="SHIP",A1="Postal"),+IF(OR(B1="Debit",B1="Payment"),"","",+IF(AND(C1="completed"),D1,"")*),""))

I'm stuck! How should this be?

Thanks in advance
 
Maybe this:

=IF(AND(OR(A1={"Ship","Postal"}),OR(B1={"Debit","Payment"}),C1="Completed"),D1,"")
 
Back
Top