+ Start a Discussion
Mohan Raj 33Mohan Raj 33 

I want a valitation rule in following condition

I have valitation rule on the following it's allow to save the account in if any one value (in here fax, Phone, Website) is not empty. if all the value or blank it's not allowed to save the record. as followingly, 
AND ( ISBLANK ( Fax ) && ISBLANK ( Phone ) && ISBLANK ( Website ) )

But now I want to change the validation rule to the following condition:
if the (fax, Phone, Website) is all values are blank it gives the error message.
If the any one value(in fax, Phone, website) is enter then it allow to save record.
If I entered the more then one value ( like phone, Fax or fax, Website or all  in like fax, Phone, website  in fax, Phone, Website) it's also produce error.
For Answer's thanks in advance, Thank you, Mohan
Best Answer chosen by Mohan Raj 33
karthikeyan perumalkarthikeyan perumal
Hello Mohan, 

use below code for your validation. 
 
OR( 


AND(NOT(ISBLANK ( Fax ))&& NOT(ISBLANK (Phone ))),AND(NOT(ISBLANK ( Phone )) && NOT(ISBLANK (Website))),AND(NOT(ISBLANK (Website)) && NOT(ISBLANK ( Fax ))), 
AND ( ISBLANK ( Fax ) && ISBLANK ( Phone ) && ISBLANK ( Website ) ) 

)

Hope this will help you. 
mark it solved if its work for you. 

Thanks
karthik
 

All Answers

karthikeyan perumalkarthikeyan perumal
Hello Mohan, 

use below code for your validation. 
 
OR( 


AND(NOT(ISBLANK ( Fax ))&& NOT(ISBLANK (Phone ))),AND(NOT(ISBLANK ( Phone )) && NOT(ISBLANK (Website))),AND(NOT(ISBLANK (Website)) && NOT(ISBLANK ( Fax ))), 
AND ( ISBLANK ( Fax ) && ISBLANK ( Phone ) && ISBLANK ( Website ) ) 

)

Hope this will help you. 
mark it solved if its work for you. 

Thanks
karthik
 
This was selected as the best answer
Mohan Raj 33Mohan Raj 33
@karthikeyan perumal thanks for the reply.It's really help ful.