+ Start a Discussion
RDSSRDSS 

Validation rule should not fire if fields are empty

Hi,


I am comparing two fields but validation rule fires even if the fields are empty. I want to skip the condition when fields are empty. It should only compare when fields have values.

AND(  
    NOT(ISBLANK(Account__r.NomineeAddress1__c)),
(IF( Spouse_Name__c = Account__r.NomineeAddress1__c  , True, false)))

Thanks
Raman
@GM@GM
Hi,

try with nested IF statement like

IF((ISBLANK(Account__r.NomineeAddress1__c)),false,IF(Spouse_Name__c = Account__r.NomineeAddress1__c,true, false))

Regards,
GM