-
Formula fields help please
Hello all,
I am need with help with my formula, I want it to do a calculation based on a criteria using formula fields this how my formula looks:
IF(
IF( ISBLANK( npsp__Primary_Contact__c ) , value_if_true, value_if_false),
IF( Payment_method__c NOT( CONTAINS(paypal, debit card, mastercard, stewardship, work for good ) ) ,
IF( StageName CONTAINS(post, secured) ,
IF( Contact__r.Funding__c , yes)
Amount - ( Amount * 0.8)
))))
Any help on how I can this working please
If this criteria is met:
- primary contact is not blank a field
- payment method (picklist field) is not paypal, debit card, mastercard, stewardship, work for good
- stage (picklist field) is either posted or secured
- funding (picklist field) equals yes
If criteria is met I would want this to be calculated Amount - ( Amount * 0.8)
Any help would be appreciated.
Many Thanks
Log In to reply.
Popular Salesforce Blogs
10 Ways Salesforce Revenue Cloud can Drive the B2B Buying Experience
We are living in a changed world. The pandemic has disrupted sales channels and customer demands. The need for technology to accelerate revenue generation, unify processes…
DemandBlue Provided Salesforce CPQ Services to a Leading Entrance and Access Technology Company
See How A Leading Entrance and Access Technology Company Customized Their Salesforce CPQ Services with DemandBlue for Quick Adoption and Output Maximization World Leading Entrance…
Popular Salesforce Videos
Driving Gamified Interactions on Salesforce Communities With ScoreNotch | Use-Cases
A Salesforce-native, Lightning-ready solution, ScoreNotch enables you to dynamically gamify Salesforce communities. Watch this video to learn more about its use-cases. For more, please visit…
How to Set Up Salesforce Knowledge in Service Cloud
Help your customers and agents find answers they are searching for faster with Salesforce Lightning Knowledge. In this video, we will review: - All components…
What are Salesforce Editions and Pricing in Details?
Salesforce Editions and Pricing - Salesforce are providing four types of licenses Essentials, Professionals, Enterprise and Unlimited. Watch the video and if you have any…
Popular Salesforce Infographics
The Best Salesforce Certifications to Look for in 2020
Salesforce tops the charts across the world in Customer Relationship Management. It is not one of the best, but the best in the game. It is…
Salesforce Acquisitions
Salesforce acquisitions have played an increasingly important role in the CRM vendor’s growth into emerging markets, particularly in the fields of AI and eCommerce. Salesforce,…
How to Choose the Right Salesforce Partner
Choosing the right partner is a key factor that could make or break your project’s success. Salesforce is a mighty CRM platform, and that’s why…