Posted by on Apr 21, 2016 in Blog Series, Featured Blogs, Salesforce Formulas Examples, Tutorials | 8 comments

## Learn Salesforce Formulas with Examples – Part 8

Learn Salesforce Formulas with Examples – Part 8  is a part of the Blog Series inspired by a lot of problems related to formulas posted in Answers Community .Main motive for this blog is not to teach you how to begin with formula but how to keep a grip and make a better understanding on it..So stay tuned and I will be providing a lot of examples with explanations in this series which would help you understand more about formulas Example 46 User knows how to make one field required if another is filled in, but he would like to make all of the fields in a section required if ANY field in that section is entered. Let’s assume there are Five Fields Field_1,Field_2 and so on AND ( IF(ISBLANK(Field_1__c), 0, 1) + IF(ISBLANK(Field_2__c), 0, 1) + IF(ISBLANK(Field_3__c), 0, 1) + IF(ISBLANK(Field_4__c), 0, 1) + IF(ISBLANK(Field_5__c), 0, 1) > 0, IF(ISBLANK(Field_1__c), 0, 1) + IF(ISBLANK(Field_2__c), 0, 1) + IF(ISBLANK(Field_3__c), 0, 1) + IF(ISBLANK(Field_4__c), 0, 1) + IF(ISBLANK(Field_5__c), 0, 1) < 5 )...