2 Replies Latest reply on Jul 28, 2015 5:02 PM by NigelBurton

    If Statement not working

    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.