View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kentucky Hot Brown Kentucky Hot Brown is offline
external usenet poster
 
Posts: 1
Default Assistance for the IF Function

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",B 1="Payment"),"","",+IF(AND(C1="completed"),D1,"")* ),""))

I'm stuck! How should this be?

Thanks in advance