AnsweredAssumed Answered

If Statement not working

Question asked by NigelBurton on Jul 28, 2015
Latest reply on Jul 28, 2015 by NigelBurton

Title

If Statement not working

Post

Can anyone tell me why the below formula is not working:

If (( Sales_Currency = "AUD" & Container_Size = 0);(Sales_Currency & "/MT " & Incoterms_Sale & " " & Place_Of_Delivery & " plus GST");If((Sales_Currency = "AUD" & Container_Size = 40);(Sales_Currency &  "/MT " & Incoterms_Sale & " on Side Loader plus GST");If((Sales_Currency = "USD" & Container_Size = 0 );(Sales_Currency & " /MT " & Incoterms_Sale & " "  & Place_Of_Delivery))))

It is not evaluating anything just returning a result generated by the first item. I have also tried it as a Case formula but get the same results.

Any assistance would be appreciated.

Outcomes