I'm not sure how to add that portion, since the current is looking for not contains 'Sales'
AND(
NOT(ISPICKVAL(StageName,"Unqualified")),
ISCHANGED(StageName),
NOT(
OR(
CONTAINS(Division__c,"Sales"),
CONTAINS(Division__c,"Finance"),
Score__c > 0,
ISPICKVAL(Type__c,"Renewal"),
Total__c = 0.00)))
5 answers
Sorry, try this it should work -OR(AND( NOT(ISPICKVAL(StageName,"Unqualified")), ISCHANGED(StageName), NOT( OR( CONTAINS(Division__c,"Sales"), CONTAINS(Division__c,"Finance"), Score__c > 0, ISPICKVAL(Type__c,"Renewal"), Total__c = 0.00) ) ),AND( NOT(ISPICKVAL(StageName,"Unqualified")), ISCHANGED(StageName), CONTAINS(Division__c,"Sales"), Total__c <= 10000 ))