My Validation Rule:
AND ( ISBLANK ( Fax ) && ISBLANK ( Phone ) && ISBLANK ( Website ) )
Here I done the validation rule for to stored the record to the account if minimum any one of the value in fax, Phone and Website is not blank.
here I also able to given more then one value in the mentioned three field it's allow to save the record.(even it's values are given all mentioned three field's also)
If I give all fields in the blank in the record it's provide the error instant of storing record.
But Now I want to change the validation rule for the following condition:
1.If the record is allow to stored in account when only any "one" value is not blank in the fax, phone and website field in the account.
2.If I entered the more then one value(if two values given like fax and website or website and phone in like pair) in the above mentioned three field (fax, phone and Website) then it's not allow to save the record and it's given an error.
3.If I entered all the value to the record in the above mentioned field (fax, phone, website) then it's also not allowed to save the record and produce the error.
4.If I doesnot entered the any value to the (fax, Phone and website) then it's also produce the error to try to save the record.
For Answer's Thanks in advance please help me to solve this task.