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,"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested IF Help 3
Value if two cells are true 2
Format of cell 1
Formula for If "" AND "" are true... 3
Format of cell 1
How to copy the function SUM but offseted in 7 columns 2
keep source formatting when concatenating 1
Different cells that need to sum in one 4

Back
Top