i am writing a Validation like this but it won't work:
AND(
ISBLANK( Excise_Duty__c ),
OR(
NOT(ISBLANK(VAT__c)),
ISBLANK(CST__c)
),
OR(
NOT(ISBLANK(CST__c)),
ISBLANK(VAT__c)
)
)
2 answers
Please try below validarion
AND(
NOT( ISBLANK( Excise_Duty__c ) ),
AND ( NOT ( ISBLANK( VAT__c )),
NOT ( ISBLANK( CST__c ))
)
)
Please let us know if this will help you